Home Forums SQL Server 2005 Administering I want to have SQL Server Mgmt Studio to have the ability to run as a different Windows user. Some has it while others has run as Administrator. RE: I want to have SQL Server Mgmt Studio to have the ability to run as a different Windows user. Some has it while others has run as Administrator.

  • February 15, 2013 at 1:31 am

    #1588223

    Try creating a shortcut on your desktop to runas.exe (not the studio executable).

    First open a Command prompt and try the following command (you may have to change the path slightly for your version of SQL), but change the xDomain\xUserName to the one you want to use.

    You may want to remove the /savecred option to increase security by entering the password every time the application starts. It'll always ask for the password the first time.

    runas.exe /user:xDomain\xUserName /savecred "C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\Ssms.exe"

    If Management studio starts up, note the username in the Connect As dialog to make sure, otherwise correct any errors in the command and try again. Make sure to use double quotes if there are spaces in the path to the studio executable.

    Once all is working to your satisfaction...

    Create a shortcut by right-clicking the desktop | New | Shortcut

    Type or paste in the link exactly as it appeared in the DOS window.

    Click Next

    Rename the link to something useful and click finish.

    Dbl-click the shortcut the next time you want to open Studio as that user.

    ps. You can change the shortcut's icon, by going into the Properties and clicking the change icon button.

    Paste in the path to your Studio and choose an icon from the list.