Tuesday, May 24, 2011

SQL: Windows Authentication: Login with different windows account

Sometimes you logged in as one user, but you want to open SQL connection  with the different windows account using Windows Authentication.

 It's not necessary at all to login on the machine with the different account


The simple tip is run cmd. exe and type the command:
runas /user:{domain\user} "{Drive}:\{Program files}\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe"

OR

Press SHIFT and RIGHT click on the program that you want start under the different windows credentials.
You will get "Run as different user" option in the context menu: