![]() ![]() We've migrated off an ancient shoretel on prem system to zoom. Then any server you try to connect to from that instance of SSMS will be using the account you ran it as. ![]() It will then prompt you for the password and if correct will launch SSMS as that user.Įither option you choose, the user has to have permissions to run SSMS on that machine and, of course, the password has to be correct. Open a command window and type the RUNAS command: runas /user: SSMS.It will then ask you for the user and password of the other user and if successful, it will launch SSMS as that user. ![]() Hold down the shift button while right-clicking on the SSMS executable or shortcut and clicking on "Run as a different user".The other way is to use RUNAS to run SSMS as a different user. The easiest way to log in with a different Windows account is to be logged in to the machine with the different Windows account. If that's the case, then the SQL Agent was never given the permissions it needs to run everything it does in SQL Server. Sounds like you are logged in to the machine as the local admin. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |