SSMS auto connect to multiple DB Engines

• smallmoney

  SSCarpal Tunnel

  Points: 4378

  More actions

  October 25, 2011 at 11:25 am

  #245218

  Hi,

  I always open up SSMS and window comes up for instance name and credentials. After that I have to press Connect then select database engines for that to connect to more than one instance.

  Is there a way you can automate that or have SSMS connect to all your instances (of interest) once you open up SSMS.

  Thanks

• Jared

  SSC Guru

  Points: 61793

  More actions

  October 25, 2011 at 11:50 am

  #1399244

  Click on your registered servers tab (or go to view, registered servers). Once you register servers you should be able to get to them as needed.

  Thanks,

  Jared

  Jared
  CE - Microsoft