Edit

Share via

Registered Servers in SQL Server Management Studio

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW)

Registering a server in SQL Server Management Studio (SSMS) allows you to store server information for future connections.

There are two ways to register a server in SSMS.

  • Open the Registered Servers tool window in SSMS to register servers
  • Right-click on a connected server in Object Explorer and select Register...

Benefits of registered servers

Use Registered Servers to:

  • Preserve server connection information.
  • Quickly connect to Object Explorer and Query Editor for a registered server.
  • Determine if a server is running.
  • Easily open a multi-server query editor.
  • Organize server information in groups.
  • Provide a detailed description for a server groups.
  • Provide user-friendly names for servers.
  • Provide detailed descriptions for registered servers in a Central Management Server (CMS).
  • Export registered server information.
  • Import registered server information.
  • View the SQL Server log files for online or offline instances of SQL Server.

Use the following articles to get started with Registered Servers:

Description Article
Register local server instances Register a connected server in SQL Server Management Studio
Register a server Create a new registered server in SQL Server Management Studio
View registered servers View registered servers in SQL Server Management Studio
Remove a registered server Remove a registered server in SQL Server Management Studio
Change a server's registration Change a server's registration in SQL Server Management Studio
Connect to a registered server Connect to a registered server in SQL Server Management Studio
Disconnect from a registered server Disconnect from a registered server in SQL Server Management Studio
Move a registered server or server group Move a registered server or registered server group in SQL Server Management Studio
Change the name of a registered server or server group Change the name of a registered server or registered server group in SQL Server Management Studio
Create or edit a server group Create or edit a server group (SQL Server Management Studio)
Remove a server group Remove a server group in SQL Server Management Studio
Export registered server information Export registered server information in SQL Server Management Studio
Import registered server information Import registered server information in SQL Server Management Studio
Create a Central Management Server and server group Create a Central Management Server and server group in SQL Server Management Studio
Execute statements against multiple servers simultaneously Execute statements against multiple servers simultaneously in SQL Server Management Studio

Related content