Friday, December 28, 2012

Connect to SSMS through other domain-user's Windows Authentication

Usually we have only two options to run the SQL Server Management Studio (SSMS):
1. Windows Authentication
2. SQL Authentication
Ofcourse everyone knows this :)

Obviously, Windows Authentication works with currently logged-in user.
But sometimes, we need to run SSMS with other domain user i.e who had little more permissions than us.

To do so the trick is to Create a shortcut for SSMS as follows:

C:\WINDOWS\system32\runas.exe /user:DOMAIN-NAME\USERNAME /netonly "C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe"

Provisw domain and username of the user specifically. While opening SSMS, it opens command prompt and concern user's password to be entered.

Thats it, now we can have SSMS opened in another user's Windows Authentication mode.

Hope it helps you too.

No comments: