Open ssms with different user

Bharat Guru
Bharat Guru used Ask the Experts™
on
What is the difference between press and hold shift key and click on SSMS executable and directly clicking on SSMS executable and enter the same credential?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
"Batchelor", Developer and EE Topic Advisor
Top Expert 2015
Commented:
There is nothing happening if you shift-click on SSMS. If you shift-right-click in Exporer, you get an advanced context menu. Or do you mean ctrl-shift-click, which is the same as "Run As ..."?
If you just click SSMS, no credentials should be asked. Only if it set up to always run as administrator in the compatibility settings of your user profile or the machine, then you are always asked for admin credentials (if having the recommended User Account Control settings applied).
Nakul VachhrajaniTechnical Architect, Capgemini India
Commented:
If you want to run SSMS using a particular domain user context, the only option is to use Ctrl+Shift+Click / Run-As functionality.

Administrators typically work with SQL Servers hosted in different domains to which access has been provided only to users in that domain. In order for them to connect to these servers using Windows Authentication, they would need to run the process with those credentials. That's when one would use the "Run As" option.

If you directly launch SSMS and try to enter Windows Credentials manually, it will not work. Windows Authentication works on the basis of the user context rather than a user name/password.
Qlemo"Batchelor", Developer and EE Topic Advisor
Top Expert 2015
Commented:
If we are talking about "Windows Authentication" versus "SQL Authentication", that is something different (and might be meant here). Yes, Windows Authetnication does not allow for explicit credentials if in SSMS already, you need to run SSMS as that user, not configure the connection to use that user.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial