Press "Enter" to skip to content

SSMS 2016 Run As issue on Windows 10

As highlighted in a number of Connect items, attempting to run SQL Server Management Studio 2016 as another user (e.g. by using Shift + right-click) results in a message stating that “This task requires the application to have elevated permissions”.

This issue affects Windows 10 1607 & 1703 but is apparently resolved by KB4016240. Prior to that, I solved it using the following method:

Locate Ssms.exe. On my PC this was located at C:\Program Files (x86)\Microsoft SQL Server\130\Tools\Binn\ManagementStudio.

Right-click Ssms.exe & click Properties, then the Compatibility tab. Click “Change settings for all users”. Select the tick box which says “Run this program as an administrator” & click Ok twice to close the Properties.

01_ChangeSSMSSettings

After the setting has been changed, you should be able to run SSMS as another user, although there will be a warning pop-up each time you launch SSMS (either as the current user or using Run As). Click Yes to launch SSMS.

02_AdminMessage

Be First to Comment

Leave a Reply

Your email address will not be published. Required fields are marked *