Thursday, July 19, 2012
How to use RunAs with SQL Server Management Studio and creating Quick Lunch
DBA having two separate account is normal practice in industry standard. In that case it is require often require to connect SSMS with different account. Run As is option for that.
There are two ways to connect SSMS with Run As
1. Press and Hold Shift Key and Right Click on SSMS gives you option for Run As.
2. Run as different user using Command Prompt and creating short cut helps you to quick login
Open command prompt and type runas /?
C:\runas /user:domain\spatel "C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe"
It is easy to create shortcut for this.
Right click on desktop and click on create new short cut
And type above command in target. Adding this short cut to Quick Launch helps you to easy login in SSMS with ran as option. This will only ask for password so no need to enter user name everytime.