Managing List of MSSQL Servers via SSMS in 5 Simple Steps

It is really a hassle to manage a list of Microsoft SQL Servers (MSSQL Server) via Microsoft SQL Server Management Studio (SSMS) especially when it requires you to manage multiple database connections.

I admit that one of the grave mistake that I did was to use the Server name dropdown list in the Connect to Server dialog box to select the database that I wish to connect as highlighted below:

Drop down list in SSMS
If you use this dropdown list, I wish you best of luck!

As more database servers connected, your Server name dropdown list became longer and longer til it reaches to an unmanageable state. Fortunately, there is a “connection manager” or “server manager” for you to keep a list of database server that you connects to and as well as giving it a meaningful name. So, instead of i.have.a.long.domain.name.sql.server.dl.my, you can just set it to: Dawa’s Law DB Server. Meaningful, isn’t it? Let’s get down to manage your connections list.

Step 1: Start SSMS, go to View –> Registered Servers. or just use this keyboard shortcut (CTRL+ALT+G)

Registered Servers Window
Registered Servers Window

Step 2: Right click Local Server Groups –> New Server Registration

New Server Registration
New Server Registration

Step 3: Fill in the details of your database server. Do set a meaningful name for Registered server name text box.

New Server Registration Dialog
New Server Registration Dialog

[adrotate banner=”1″]

Step 4: Click Test to test the connection. Followed by Save.

Test Connection
Test Connection

Step 5: Connect to the database server of your choice.

A well managed MSSQL Server connections list
Well Managed MSSQL Server Connections List

Now, we have a well managed MSSQL Server list. 🙂

Leave a Reply