I am running SSMS as a different user
from my local machine and it works fine.
When I try to do the same, even using my own credentials, on server01
I get the following error:
access is denied
I am currently in the Administrators
group in that server:
The way to run ssms as a different user is:
1- right clink on the ssms icon if it is already running otherwise follow from 2
2- witht eh shift key pressed right click the ssms icon and it will give you the options as shown on the picture below.
considering the password is correct and I am sysadmin
what could be missing?
Best Answer
I noticed you are running version 130. Apparently SSMS 2016 fails to run as different user as reported below. I have experienced this myself. Quite frustrating.
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/1315261c-0d9e-49bf-8334-6c0195015598/ssms-2016-fails-on-windows-10-version-1607-while-trying-to-execute-it-as-a-different-domain-user?forum=sqltools
https://connect.microsoft.com/SQLServer/feedback/details/3009405/ssms-2016-fails-on-windows-10-version-1607-while-trying-to-execute-it-as-a-different-domain-user