Adding a Database Server Registration

Before you can add a database, you must set up the database server registration.

  1. Right-click the required server node and select All Tasks, Register Database Server.

    The Register DB Server dialog box is displayed.

  2. In the DBMS registration alias name field, enter a name to identify the database server registration.

  3. In the Server machine field, enter the name of the database server. If the database is local, enter localhost. Otherwise, enter the remote database server name. If the database server is in a cluster, enter the database cluster name.

  4. In the Instance name field, enter the SQL Server Instance name. If the SQL server instance on the database server is the default instance, leave this field blank.

  5. Click OK to add the database server registration node to the runtime server node.