Tag Archives: ssms

Windows Authentication outside the domain

For 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:SANDBOX\username "C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\Ssms.exe"