How to create SQL Registered Servers

1.       Open SSMS and select Registered Servers from View(Cntrl+Alt+G)

2.       Expand the Database Engine Node, right click on Local Server Groups and select “New Server Group”

 

3.       Choose the desired name and description for the server group and click “Ok”

 

 

4.       Right Click on the newly added Server group and select “New Server Registration”

 

 

5. Specify the server name in the “Server Name” text box and desired display name in “Registered Server Name” text box and navigate to “Connection Properties” tab.

6. Choose “Browse server” from the “Connect to database” dropdown list and click “Yes” when prompted for confirmation.

7.       Browse and select the relevant database, and click on Test to test if the connection is successful.

8. Click “Ok” and then “Save” to add this server to your local group.
9. Repeat the steps 1-8 to add more servers.

     10. Right click on the server group and select New Query

  11. Execute your query in the query editor, notice that the an additional column is included in your query results that calls out the server name