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.

Improve this question
1
  • 1
    Closest I have seen is creating a group in registered servers and opening a connection to all those servers by one click.
    – SqlWorldWide
    Commented Apr 19, 2017 at 12:02

2 Answers 2

Reset to default
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.

Improve this answer
1
  • 1
    Oh Nice, Will try it and post results. Thanks
    – Racer SQL
    Commented Apr 19, 2017 at 12:06
0

You can use free "SSMSConnect" extension for SSMS, which I developed to solve this issue.

https://github.com/ikarasin/SSMSConnect

SSMS versions 18 and 19 are currently supported.

Improve this answer
2
  • Hi Ilia, this is the second identical answer and it is starting to look like spamming. Please read the help on self promotion and explain a bit about your program.
    – Rohit Gupta
    Commented Jan 1 at 10:06
  • Hi Rohit, when I firstly faced this issue, Google led me to a couple of threads here, and no solution in them (I checked SSMSBoost and it doesn't seem to support latest version of SSMS, and seems to be abandoned in 2021). So I developed my own tool, and just returned to these threads to share it, so people with the same request could use it. Didn't mean to spam of course. Thanks!
    – Ilia Karasin
    Commented Jan 2 at 9:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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