New Information - SQL Server 2000 SP3.
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.
Security Note For maximum security, you should select to prompt for the login name and password when possible.
- The name of the group where you want the server to be listed after it is registered.
You also can optionally display the Microsoft® SQL Server™ state in the console, start an instance of SQL Server automatically, 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 automatically registers all instances of a local SQL Server. However, if you have one instance of SQL Server registered, and then install more instances of SQL Server, only the original instance of SQL Server will be registered. You can launch the Register Server Wizard or use the Registered SQL Server Properties dialog box to register additional servers. The Registered SQL Server Properties dialog box is populated with the names of all local instances of SQL Server.
If you have difficulty connecting to the remote server, you can use the 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