Export (0) Print
Expand All
1 out of 4 rated this helpful - Rate this topic

Registering Servers

SQL Server 2000

  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

Enterprise Manager

Transact-SQL

SQL-DMO

To remove a server running SQL Server

Enterprise Manager

SQL-DMO

To change a server's registration

Enterprise Manager

SQL-DMO

To connect to a registered server running SQL Server

Enterprise Manager

To disconnect from a registered server running SQL Server

Enterprise Manager

See Also

Configuring Remote Servers

Client Network Utility

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.