SQL Server Management Studio interface will prevent you from using domain other than the one you are currently login as. To use another domain, use a .bat file runas.

SSMS 17

cd C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\
runas /user:domain1\user1 /netonly Ssms.exe 

SSMS 18

D:
cd D:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\
runas /user:domain1\user1 /netonly Ssms.exe 

Profiler

cd "C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn" 
runas /user:domain1\user1 /netonly PROFILER.exe

Last modified: April 21, 2020

Author

Comments

Write a Reply or Comment