How to connect to SQL server from Management Studio using Windows Authentication as a different user?
You can connect SQL server from Management studio as a different windows
user using the run as command. To accomplish the same do the below.
Press Windows Key + R or Open Command Prompt
Type the below command to Open “SQL Server Management Studio” with
a different user
runas /user: " Ssms.exe location in
your machine"
Example :
runas /user:MYDOMAIN\Rajesh "C:\Program Files
(x86)\Microsoft SQL Server\120\Tools\Binn\ManagementStudio\Ssms.exe"
To get your SQL Server
Management Studio Location . Right click on “SQL Server Management Studio” from
start menu and in context menu click “Open File Location”. This will take you
to the Ssms.exe location.
No comments:
Post a Comment