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 have SQL Server 2008 R2 installed on a Windows Server 2008 R2 box. There is no domain in the network.

Is there any way for me to add a Windows Login on SQL Server for a non-local and non-domain user? For instance, if the server is Server1 and a PC on the network is PC1, how can I add PC1\User1 as a Windows Login on the SQL Server instance installed on Server1?

share|improve this question

1 Answer 1

up vote 4 down vote accepted

Create matching usernames and passwords. It really is that simple. For your example, create an account for User1 on Server1 with the same password as on PC1.

Just in case this is an issue you're having with connecting SSMS with a non-domain account, that requires jumping through an additional hoop. Some applications don't support stored usernames and passwords via the windows credential store. SSMS is one of them.

I have a bunch of runas shortcuts to deal with connecting SSMS to a variety of servers in different domains:

C:\Windows\System32\runas.exe 
/netonly 
/user:DOMAIN\USER 
"C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe"

You could also make use of the SysInternals ShellRunAs extension.

share|improve this answer
1  
FWIW it took a lot of teeth-pulling but I was ultimately able to get credential manager to pass Windows credentials from the store to the remote server using SSMS. I had to add the FQDN to my hosts file and then ipconfig /dnsflush before it would recognize and match the credential server name. –  Aaron Bertrand May 29 at 1:30

Your Answer

 
discard

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