Thursday, November 18, 2010

Supply alternate Windows credentials to SSMS

If you need to log into SQL Server Management Studio with a different set of credentials to the one you are already logged into, it is possible to run SSMS from a CMD prompt with a different username:

>runas /user:DOMAIN\USERNAME “C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe”

Type in the associated password when it prompts you and voila!

No comments:

Post a Comment