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. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
In that case, sorry, then your objective is not achievable without having domain accounts. – RoKa Apr 10 '13 at 9:38
Using the same user name and password on both machines should work (this is also called pass-through authentication). If it doesn't, there's something else in your environment that's preventing that from working -- it's not a SQL Server problem. – Jon Seigel Jun 2 '14 at 14:07

Your Answer


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

Browse other questions tagged or ask your own question.