SQL Sever registration server [SQL Server]

Registered servers window:

You can use SSMs to register multiple servers and connect them, so that DBA can manage multiple local or remote servers in one environment. The registered servers window is invisible by default. to display it, click the View menu to select the registered servers option, or press the shortcut key CTRL + ALT + G.

Right-click any location in the registered servers window, open the context menu, register a new server through the menu, or create a server group.

If the company has multiple servers, the server group is very useful. For example, Server registration can be performed in segments. All test and Development servers are put in one group, and the product servers are put in another group, or the servers are grouped by responsibility or department. The database engine, report service, integration service, and SQL Server compact edition can be registered in the registered servers window. After registration, the registered servers window can manage related services, or quickly connect the Object Browser to the server, such: