1

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?

  • 2
    Are you asking about Management Studio? You could just register the servers that way you don't have to use the connect window again. – Tara Kizer Aug 25 '16 at 2:20
  • Please explain what you are really trying to achieve. Depending on what's the use case, there might be better solutions like sqlcmd mode or multiserver environment that satisfy the actual need. – vonPryz Aug 25 '16 at 5:40
  • Judging by your response to @Tara's answer, you do seem to be talking about SSMS, so I've edited mentions of it in to your question. – Andriy M Aug 25 '16 at 5:44
4

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.

  • Any way to get them to automatically pop up in Object Explorer? – ravp Aug 25 '16 at 2:32
  • Drag registered servers on top of object explorer and it will tab then out. Then you have the option to close out object explorer and the next time you open it should show all your registered servers. – Jason Cumberland Aug 25 '16 at 7:56
1

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.

0

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.