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
Comments