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

cd C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\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: June 26, 2019

Author

Comments

Write a Reply or Comment