How can you save connections in Object Explorer? RRS feed

  • Question

  • Is there a way to save connections in Object Explorer so that each time you start Management Studio you will be automatically connected to some servers?  Ideally something similar to the way it was in SQL 2000 Enterprise Manager where the servers would be displayed and you would only have to expand them to view their info.   Instead, currently you have go to the Registered servers, right click, Connect Object explorer.

    Thanks in advance.
    Tuesday, June 2, 2009 2:30 PM

All replies

  • You have a REGISTERED SERVER window available in Management Studio CTL+ALT+G. Register once and its done

    • Proposed as answer by Nick Kavadias Tuesday, June 2, 2009 2:40 PM
    Tuesday, June 2, 2009 2:38 PM
  • But once it is registered, you still have to right click, highlight connect, and click Object Explorer in order to establish the connection.  Is there a way that you can establish the connection without having to do that?
    Tuesday, June 2, 2009 2:48 PM
  • In SSMS 2008, you can double-click a registered server and it opens up in Object Explorer - pretty close. You can even double-click a server group, and all server opens in Object Explorer.
    Tibor Karaszi, SQL Server MVP
    Tuesday, June 2, 2009 3:51 PM
  • Double click does seem to work in 2k5 as well.  Not exactly the same but definitely a lot better than going through the extra clicks.
    Tuesday, June 2, 2009 5:20 PM
  • Worked, Thanks
    Wednesday, September 18, 2019 3:31 AM