0

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: enter image description here

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.

enter image description here

considering the password is correct and I am sysadmin what could be missing?

enter image description here

1

It sounds like the Windows account that you're using on your local machine has enough permission to launch SSMS, but that same Windows account does not have permission on the server. Grant the appropriate permission to the Windows account on the server to be able to launch SSMS, and then it should work fine.

Unless...you're referring to a SQL Server "cannot connect" error...then the answer is different. :)

  • my account is administrator on that server and also I am domain admin – marcello miorelli Sep 1 '17 at 15:00
  • 1
    But does the user you're trying to enter in the Run As... have permissions, too? Both accounts need rights to log in on the server. – CaM Sep 1 '17 at 15:03

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.