How can I get SQL Server Management Studio 2012 to connect to multiple servers automatically on open?

Posted on

Question :

When I open SQL Server Management Studio, it only connects to a single Database Server, but I would like it to automatically connect to multiple Database Servers.

How can I accomplish this?

Answer :

In Management Studio, go to the View menu and then Registered Servers. Register each of the servers that you want to keep connections for. Then when you open up Management Studio in the future, you just have to go to your register servers and click the ones you need. You can also use the Central Management Servers feature if there are multiple people on your team that would like to share the registered servers. You can group them in various ways, such as by version, by environment, by location, etc.

If you’re open to installing an AddOn to SSMS, try SSMSBoost – it does this and so much more…(http://www.ssmsboost.com/) – I’m not affiliated with SSMSBoost, but I love this tool!

As found at this link

https://serverfault.com/questions/44968/how-can-i-have-sql-server-management-studio-2008-connect-to-my-instances-automat

If you use the SSMSBoost plugin, then you can set any of your preferred connections to “Connect object explorer at startup”. This option can be found on the SSMSBoost->Settings->Preferred Connections->List page of the connection.

before to connect with management be sure to register the name of the server on the file host in your machine (current S.O where is your SQL management studio).
In this way you can connect to the server by your name.

The path on windows to found the file is C:WindowsSystem32driversetchost right there are examples of how to do.

Leave a Reply

Your email address will not be published.