Subscribe to RSS feed  Follow @jackvamvas - Twitter

*Use the Comments section for questions Links


SQL Server DBA Jobs

How to Run SSMS as a different user

18 November,2021 by Tom Collins

Question : I've SQL Server Management Studio (SSMS) installed and attempting to run it as a different user. I'm doing the Right Click on the ssms.exe  - but can only see Run as Administrator , not Run as different user .


Answer:    Run as different user is available It's actually available - but instead of Right Click , use       Shift - Right Click     .




The alternative is to run through the command line  - which is  my preference - 


--example 1 : the full path to SSMS

--depending on ssms version it may differ on your desktop

RUNAS /user:MYDOMAIN\MYID "C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Ssms.exe"

--example 2 : using ssms shortcut



Read more on SSMS 

How to start SSMS as Administrator

How to add SSMS to the PATH variable with Powershell

How to recover SSMS auto recover scripts after crash

How to start SSMS as a different Windows login

How to fix System.OutOfMemoryException when using SSMS


Author: Tom Collins (


Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.


Post a comment on How to Run SSMS as a different user | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer