Read in English
Read in English Feedback Edit

Register Servers

  • Commodity
  • 2 minutes to read

Applies to: yesSQL Server (all supported versions) YesAzure SQL Database YesAzure SQL Managed Instance yesAzure Synapse Analytics yesAnalytics Platform System (PDW)

Registering a server in SQL Server Management Studio allows you to shop the server connection information for future connections.There are 3 means to annals a server in SQL Server Direction Studio.

  1. Local instances of SQL Server are automatically registered during the first launch of Management Studio after its installation.

  2. You can also initiate the automated registration procedure at any time, to restore the registration of local server instances.

  3. Lastly, y'all can register a server using the Registered Servers tool in SQL Server Direction Studio.

Benefits of Registered Servers

With Registered Servers you tin:

  • Register servers to preserve the connection information.

  • Determine if a registered server is running.

  • Easily connect Object Explorer and Query Editor to a registered server.

  • Edit or delete the registration information for a registered server.

  • Create groups of servers.

  • Provide user-friendly names for registered servers by providing a value in the Registered server name box that is unlike from the Server name list.

  • Provide detailed descriptions for registered servers.

  • Provide detailed descriptions of registered server groups.

  • Export registered server groups.

  • Import registered server groups.

  • View the SQL Server log files for online or offline instances of SQL Server.

Use the following topics to get started with registered servers:

Clarification Topic
Annals local server instances Annals a Continued Server (SQL Server Management Studio)
Register a server Create a New Registered Server (SQL Server Direction Studio)
View registered servers View Registered Servers in SQL Server Management Studio
Remove a registered server Remove a Registered Server (SQL Server Direction Studio)
Change a server's registration Change a Server's Registration (SQL Server Direction Studio)
Connect to a registered server Connect to a Registered Server (SQL Server Management Studio)
Disconnect from a registered server Disconnect from a Registered Server (SQL Server Management Studio)
Motion a registered server or server group Move a Registered Server or Registered Server Group (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 (SQL Server Management Studio)
Create or edit a server grouping Create or Edit a Server Grouping (SQL Server Direction Studio)
Remove a server group Remove a Server Group (SQL Server Management Studio)
Export registered server information Export Registered Server Information (SQL Server Direction Studio)
Import registered server information Import Registered Server Data (SQL Server Management Studio)
Create a Key Management Server and Server Group Create a Central Management Server and Server Group (SQL Server Management Studio)
Execute statements against multiple servers simultaneously Execute Statements Confronting Multiple Servers Simultaneously (SQL Server Direction Studio)

See Also

Remote Servers