Running SSMS With Different Windows Account
Recently I was trying to access SSMS with another account, I had two options,
First to log off and log in again with another account.
Second, In AX we have already seen that we can Run AS, So Run AS.
Many companies provide two different windows account to their Administrator.
One “regular” account (example Google\umeshp) is used for general work like emails, log in to laptop etc.
And another “admin” account (example Google\adm_umeshp) for administrative level tasks to be done on the server.
The regular account would have no access to SQL Servers, but the admin – level account would.
To make security stronger, the companies use a Windows account to connect to SQL Server.
This makes thing little interesting. If one has to connect to SQL Server from the laptop where the DBA has logged in with the regular account, he/she has to do “Right Click” with Shift key pressed and then use “Run as Different User” to use the admin account.
Pressing shift key is important otherwise we would not see that option. After choosing that, it would pop-up with username and password window. If you notice, you would notice ssms.exe path which is used.
Recently I was trying to access SSMS with another account, I had two options,
First to log off and log in again with another account.
Second, In AX we have already seen that we can Run AS, So Run AS.
Many companies provide two different windows account to their Administrator.
One “regular” account (example Google\umeshp) is used for general work like emails, log in to laptop etc.
And another “admin” account (example Google\adm_umeshp) for administrative level tasks to be done on the server.
The regular account would have no access to SQL Servers, but the admin – level account would.
To make security stronger, the companies use a Windows account to connect to SQL Server.
This makes thing little interesting. If one has to connect to SQL Server from the laptop where the DBA has logged in with the regular account, he/she has to do “Right Click” with Shift key pressed and then use “Run as Different User” to use the admin account.
Pressing shift key is important otherwise we would not see that option. After choosing that, it would pop-up with username and password window. If you notice, you would notice ssms.exe path which is used.
Happy SQLing!
Thanks & Regards,
Mail ID: pandit.umesh@hotmail.com
Skype ID: pandit.umesh
No comments:
Post a Comment