How To Connect SQL Server via SSMS(SQL Server Managemet Studio) With Different Domain Account

 

In some cases, you may need to connect to the sql server via SSMS with a different domain account(for windows authentication).

You connect to the cmd command line and run the following command by going to the path to the version of SQL Server that you are using.

The path for SQL Server 2014 is generally as follows.

“C:\Program Files (x86)\Microsoft SQL Server\120\Tools\Binn\ManagementStudio”

 

It may be difficult to do this every time. So you should go to this path once and create the shortcut of ssms.exe on the desktop as follows.

 

After creating a shortcut of ssms.exe on the desktop, we press shift and right click on that shortcut.

Then click Run as different user as below to enter the user information we want to connect.

dbtut
Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *