Open ssms with different user

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?
Bharat GuruAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Qlemo"Batchelor", Developer and EE Topic AdvisorCommented:
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).

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Nakul VachhrajaniTechnical Architect, Capgemini IndiaCommented:
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 AdvisorCommented:
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.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.