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?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
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
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:\Windows\System32\drivers\etc\host right there are examples of how to do.