Using Registered Servers to Manage Servers

SQL Server Management Studio allows you to manage large numbers of servers. Use Registered Servers to organize servers that you access frequently. With Registered Servers you can:

  • 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 different 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.

See Also

Other Resources

Introducing SQL Server Management Studio
How to: View Registered Servers in SQL Server Management Studio
How to: Create a Server Group (SQL Server Management Studio)
How to: Export Registered Server Information (SQL Server Management Studio)
How to: Import Registered Server Information (SQL Server Management Studio)
How to: Change a Server's Registration (SQL Server Management Studio)
How to: Remove a Registered Server (SQL Server Management Studio)
How to: Connect to a Registered Server (SQL Server Management Studio)
How to: Disconnect from a Registered Server (SQL Server Management Studio)

Help and Information

Getting SQL Server 2005 Assistance