Diary

May 20, 2010

Windows authentication and run as

Filed under: Uncategorized — Himanshu @ 5:58 am

We have multiple DCs in our organization for a reason, and we need to access SQL Server hosted on different DC several times. To login into SQL Server using windows authentication I use following:

C:\Windows\System32\runas.exe /netonly /user:<different domain name>\<username of different domain name”> "C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe"

Powered by WordPress