Home | Previous Page | Next Page   Appendix F. SQLHOSTS Registry Key (Windows) > Preparing the SQLHOSTS Connectivity Information >

Setting Up the Database Server Group Registry Key

After you create the registry key for the database server, you must make a registry key for the database server group that includes the database server. For more information, refer to Verifying SQLHOSTS.

Tip:
In this manual (and in Figure 25), each of the names of the database server groups are the database server names prefixed by g_. The g_ prefix is not a requirement; it is just the convention that this manual uses.
To set up the database server group registry key
  1. With the SQLHOSTS key selected, choose Edit > Add Key.
  2. In the Add Key dialog box, type the name of the database server group in the Key Name dialog box.

    This value must correspond to the Options value in the database server name key.

    Leave the Class dialog box blank. Click OK.

  3. Select the new key that you just made (the key with the database server group name).
  4. Choose Edit > Add Value.
  5. In the Add Value dialog box, type one of the fields of the sqlhosts information (HOST, OPTIONS, PROTOCOL, SERVICE) in the Value Name dialog box.

    Do not change the Data Type dialog box. Click OK.

  6. In the String Editor dialog box, type the value for the field that you selected and click OK.

    For a database server group, enter the following values:

    HOST       -
OPTIONS    i=unique-integer-value
PROTOCOL   group
SERVICE    -

    Each database server group must have an associated identifier value (i=) that is unique among all database servers in your environment. Enter a minus (-) for HOST and SERVICE to indicate that you are not assigning specific values to those fields.

  7. With the database server group key selected, choose Edit > Add Key.
  8. In the Add Key dialog box, type the name of the database server in the Key Name field.

    This value must correspond to the database server key, whose OPTIONS value was set to the database server group key selected in step 7.

    If you are combining Enterprise Replication with HDR, create keys for primary and secondary HDR servers under the same database server group.

  9. Repeat steps 1 to 8 for each field of the sqlhosts information.

    Figure 25 illustrates the contents of the database server group registry key after you add the values to the keys.

    Figure 25. Database Server Group Information in the Windows Registry
    begin figure description - This figure is described in the surrounding text. - end figure description
  10. Exit from the Registry Editor.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]