Monday, November 26, 2012
How to open a program in Windows 2008 and above using a different Windows account?
Before Windows Server 2008 there used to be an option to open a program like SQL Server Management Studio using different Windows account. You can open any program and say “Run as”.
This was helpful when you have domain accounts running SQL Services.
But in Windows 2008 and above "Run as" option has been removed.
So to open SSMS as some other domain account you can use following command in command prompt
runas /netonly /user:domain\user "C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe"
Change domain\user and program file exe file