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
No comments:
Post a Comment