Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I am having sql server 2008 r2 express installed in a PC. I have some other PC which are connected to this pc in a local network.Now those PC connect to my pc's sql server using sql authentication. But now i want them to able to connect sql server in my pc using windows authentication. How other pc can connect to sql server installed in another pc using windows authentication?Please give me step by steps method of doing it.

share|improve this question
    
If you say "local network", do you imply that you are networking using a Windows Workgroup, or are you using Active Directory? –  RoKa Apr 10 '13 at 8:45
    
@RoKa I am using windows workgroup –  Navaneeth Apr 10 '13 at 9:14
    
As far as I know, you cannot use normal Windows Authentication in a Workgroup, because by definition, a Workgroup is not trusted. I believe that there is a way to use Named Pipes to connect with a windows account, but I have never used that, and a quick google search said it does not always work. What you could try too, is to set up mirrored accounts. What that means is that you create the same identical account on both machines with the exact same password. You then grant access to the local account. I have had mixed success with this approach though. –  RoKa Apr 10 '13 at 9:25
    
@RoKa As you said creating a same account on both PC will not work i guess. Because when create a login with windows authentication the login name looks like "PCname\username". But if create same user in another pc then it will have different pc name and when connecting through SSMS the username part will be "PCnameofthisnewpc\username" I cant change the account here also bcoz of windows authentication and login fails due to different pc name even though i hav same username and password –  Navaneeth Apr 10 '13 at 9:32
2  
In that case, sorry, then your objective is not achievable without having domain accounts. –  RoKa Apr 10 '13 at 9:38

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.