Windows Authentication outside the domain

01_Vault_101_Citizenship_AwardFor DBAs using a laptop or system off the domain, a frequent problem I’ve noticed is creation of a sql login to access the server because their laptop is not joined to the domain (some DBAs have multiple networks to administrate)

nubs

Here is an example of running SSMS with your active directory login. I’ve updated this post to work with SQL Server 2012. Assuming you haven’t changed any of your paths where your management studio is located, this should work. Make sure you enter in your username.

C:\Windows\System32\runas.exe /netonly /user:DOMAIN\username "C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\Ssms.exe"


You will want to update the above command to reflect the path on your own system

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.