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     .

 

Run_as_different_user

 

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

RUNAS /user:MYDOMAIN\MYID ssms

 

Read more on SSMS 

How to start SSMS as Administrator

How to add SSMS to the PATH variable with Powershell

 


Author: Tom Collins (http://www.sqlserver-dba.com)


Share:

Verify your Comment

Previewing your Comment

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

Working...
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.

Working...

Post a comment on Run SSMS as a different user


sqlserver-dba.com | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer