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:
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)
Step 2: Right click Local Server Groups –> New Server Registration
Step 3: Fill in the details of your database server. Do set a meaningful name for Registered server name text box.
Step 4: Click Test to test the connection. Followed by Save.
Step 5: Connect to the database server of your choice.
Now, we have a well managed MSSQL Server list. 🙂