0

Maybe this question is a little off topic, I will close if necessary, but, is there a way to configure Management studio, to when I open it, it starts already with x connections? So I don't need to start it and connect to x instances every time.

  • 1
    Closest I have seen is creating a group in registered servers and opening a connection to all those servers by one click. – SqlWorldWide Apr 19 '17 at 12:02
4

I'm not sure of a way to do this 'natively' in SSMS, but I've been using SSMS Boost for years and it has that functionality (and a whole lot more). It's a plugin for SSMS and they have a 'free' community version that just needs to be re-downloaded every few months.

Check here and scroll down until you see Download links (updated on 14-th of March 2017):

After installation, there will be a new menu bar option 'SSMSBoost'. Click on the menu bar and select 'Settings'. Then look for 'Preferred Connections'. There, you will have a checkbox to open a defined connection on SSMS startup.

enter image description here

You can 'add' preferred connections by clicking the 'plus' sign at the bottom of the screen. Preferred connections also allow you to specify an 'Important DB Alert' that will actually be displayed on new query windows - I use mine to inform me I'm in a 'production' database.

  • 1
    Oh Nice, Will try it and post results. Thanks – Racer SQL Apr 19 '17 at 12:06

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.