Can’t do a Run-As Another User on SQL Server Management Studio in Windows 10/Server 2012

Create the following shortcut:

C:\Windows\System32\runas.exe /netonly /user:domainhere\Usernamehere “C:\Program Files (x86)\Microsoft SQL Server\130\Tools\Binn\ManagementStudio\Ssms.exe” as the Target.

When the user clicks on this shortcut, a Command window will appear asking for the password to the domainhere\usernamehere account. You can either copy and paste the password or just start typing in the window — you won’t see the text. Hit enter, and SQL Server Management Studio should open.

Leave a Reply

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