Registering Servers

You must register a local or remote server before you can administer and manage it by using SQL Server Enterprise Manager. When you register a server, you must specify:

• The name of the server.
• The type of security used to log on to the server.
• Your login name and password, if appropriate.
• The name of the group where you want the server to be listed after it is registered.

You can also optionally display the Microsoft® SQL Server™ state in the console, start SQL Server automatically when connecting, or show system databases and system objects. The first two options are selected by default when you register a server.

When you run SQL Server Enterprise Manager for the first time, it registers the local server running SQL Server automatically. Later, you can launch the Register Server Wizard or use the Registered SQL Server Properties dialog box to register additional servers.

If you have difficulty connecting to the remote server, you can use the SQL Server Client Network Utility to configure access to the server.

To register a server

To remove a server running SQL Server

To change a server’s registration

To connect to a registered server running SQL Server

To disconnect from a registered server running SQL Server

See Also

Configuring Remote Servers