Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Select different user while connect to SQL Server with Windows Authentification

I'm trying to connect to SQL Server by using Windows Authentication with Microsoft SQL Server Management Studio. I have several users created on the machine that runs SQL Server.

Login dialog box won't allow to select other users, except the one that is logged in for the current Windows session.

How can I log into Management Studio as a different user?

enter image description here

like image 620
vico Avatar asked Apr 14 '26 10:04

vico


1 Answers

Right-click the SSMS icon, hold Shift, then right-click Microsoft SQL Server Management Studio with the year of the version you have installed and select Run as Different User. You will be prompted for Windows login credentials that will be used in Windows authentication in SSMS. You can use another Windows account here and then use SSMS as you typically would without making any additional changes.

like image 60
userfl89 Avatar answered Apr 16 '26 22:04

userfl89