How to register a server (Enterprise Manager)

How to register a server (Enterprise Manager)

To register a server

1. Right-click a server or a server group, and then click New SQL Server Registration.

   Note  If you selected the From now on I want to perform this task without using a wizard check box the last time you used the Register Server Wizard, SQL Server Enterprise Manager displays the Registered SQL Server Properties dialog box. Otherwise, the Register Server Wizard is started.

2. In the Server box, type the server name.
   
   
3. To specify the connection between SQL Server Enterprise Manager (as a client) and the server running the instance of Microsoft® SQL Server™ being registered, do one of the following:
   • Click Use Windows Authentication

   -or-

   • Click Use SQL Server Authentication

     With this type of connection, you must provide a login name and password. Select the Always prompt for login name and password check box to always prompt user for login name and password, rather than storing your login id and password in your registry.

4. In the Server Group list, click a server group.

   Note  If the group you need does not exist yet, create it by clicking the build (...) button, and then completing the Server Groups dialog box.

5. Do one or more of the following:
   • Select the Display SQL Server state in console check box to turn on service polling.
     
     
   • Select the Show system databases and system objects check box to show all system databases and objects.
     
     
   • Select the Automatically start SQL Server when connecting check box to start an instance of SQL Server automatically.
6. Repeat Steps 1 through 5 to register each server with SQL Server Enterprise Manager.

See Also

How to create server groups

Managing Servers

Registering Servers