Local SQLHOSTS Registry Key

If you use the SQLHOSTS registry key on the local computer, for all database servers, the correct SQLHOSTS registry key must exist on all computers involved in replication. In addition, the hosts and services files on each computer must include information about all database servers.

For example, to set up replication between the server instance srv1 on the computer host1 and the server instance srv2 on host2, you must ensure the following:
  • Both host1 and host2 include SQLHOSTS registry key entries for srv1 and srv2.
  • The services file on both computers includes the details of the services used by both database server instances.