Business Intelligence Blogs

View blogs by industry experts on topics such as SSAS, SSIS, SSRS, Power BI, Performance Tuning, Azure, Big Data and much more! You can also sign up to post your own business intelligence blog.

Save Frequently Used Connections in SQL Server Management Studio

  • 25 June 2010
  • Author: DustinRyan
  • Number of views: 46977
  • 0 Comments

If you're like me, you probably have a significant number of servers you access on a regular basis, which means every time you start up SQL Server Management Studio (SSMS) you have to log in to each server typing in user names and passwords and connecting one at a time. I find this very obnoxious and annoying.

Thankfully, SQL Server Management Studio allows you to save connections to various servers via Registered Servers, which can include Database Engines, Reporting Services, Integration Services, and Analysis Services. Registered servers allow you to easily check if a server is running, create groups of servers, use user-friendly names for your servers, and import/export your registered server groups.

To view and add a registered server, start up SSMS go to View > Registered Servers. Then in the Registered Servers pane, right-click Local Server Groups and click New Server Registration.

New Registered Server

Then just enter the server name, select the authentication, key in the User name and Password if necessary, and check Remember password.

Now each time you start up SSMS, your registered servers will be viewable in the Registered Servers pane. Simply double-click the server you wish to navigate and that server will be opened within the Object Explorer.

You can read more about Registered Servers here.

Print
Tags:
Rate this article:
5.0
DustinRyan

DustinRyanDustinRyan

Other posts by DustinRyan

Please login or register to post comments.