Home > IT Answers > SQL Server > SQL Server 2005
Kingjah
15 pts.
 SQL Server 2005
SQL Server 2005, SQL Server 2005 connectivity, SQL Server Express 2005, Windows 7, Windows authentication
Is user cloning the only way to use windows authentication in sql server?

Software/Hardware used:
Windows 7, SQL SERVER EXPERESS 2005 SP3
ASKED: October 7, 2010  3:34 PM
UPDATED: October 9, 2010  5:43 PM
RELATED QUESTIONS
Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

What is user cloning?

Denny Cherry
 64,520 pts.
 

I believe it’s also impersonation of a user, That’s what I gather from my research.
I have this small business network with 5 computers running windows 7, I built an inventory tracking app with Visual Studio that connects to a SQL SERVER EXPRESS instance on my computer. all the other computers hosting my inventory app can also connect to the database hosted on my computer via the sa sqlserver login…having explained this somewhat. My problem is I would like to use windows authentication but am not able too, expect if I impersonate the user name and passwork from another computer that is trying to connect to my server instance, I realize that isn’t the way to do it but anything else gets me the infamous:”user is not assossiated with a valid sql connection. ???????????????/?

Kingjah
 15 pts.