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.
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.
Be First to Comment