How to run SQL Server Management Studio (SSMS) with different credentials on Windows 10
After Windows 10 anniversary update and with SQL Server 2016 Management Studio (SSMS), you may receive below error if you try to run as a different user:
The below workaround may solve the issue and can run SSMS under different credentials (may not work for all service accounts which are part of logon enforcement)
The below workaround may solve the issue and can run SSMS under different credentials (may not work for all service accounts which are part of logon enforcement)
- Add the service account that you would like to open SSMS under different credentials into your local machine’s administrators group
- Right click the shortcut and check Compatibility > Change settings for all users > Run this program as an administrator
No comments: