Showing posts with label ssms. Show all posts
Showing posts with label ssms. Show all posts

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!