The first time you will see a command prompt where you have to enter your password. To finish this off: click on the Change Icon button and browse to SSMS.exe to select the familiar icon. Some forums/blogs recommend the /netonly option to only use the provided user for remote access, but that often doesn't work causing SSMS not to start.Ĭhange Target field and optionally the Comment For more options check out this site or execute "runas /?" in the command prompt to show all options.The /savecred option will save the password after the first time (not in Windows 7 Home).The /user: option allows you to use a different user.RUNAS /user:myDomain\myUserName /savecred "C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\Ssms.exe" "C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\Ssms.exe" Instead of the standard SSMS command (see Target): Now you can run SSMS with a different accountĪ more permanent solution is to create a new shortcut with a runas command in it. Right click the shortcut and choose Run as different user After that the user name field for the Windows Authentication changes. Then the 'Run as different user' option appears, which allows you to enter different credentials. The quick solution is to hold the Shift-key while right clicking the SSMS shortcut in the start menu. How can I connect to a SQL Server instance in SQL Server Management Studio (SSMS) with a different user so that I can still use Windows Authentication? My company uses different Windows users for the various DWH environments (Development, Test, Acceptance
0 Comments
Leave a Reply. |