Configuring Failover for Remote Server Connections

If the interfaces file (or LDAP directory service) is set up to define a failover configuration, then Component Integration Services takes advantage of it by automatically failing over connections to the failover server if a connection to the primary server fails.

1. Enable new server option cis hafailover:

   exec sp_serveroption server_name, ’cis hafailover’, true

2. Modify directory services (interfaces file or server entries in the LDAP server) to specify a failover server. For example, you can configure server S2 to serve as a failover server for S1, and vice-versa, by additions to the interfaces file:

   S1
   		master tcp ether host1 8000
   		query tcp ether host1 8000
   		hafailover S2
   S2
   		master ether host2 9000
   		query ether host2 9000
   		hafailover S1

   See Using Sybase Failover in a High Availability System, Appendix C, for more discussion of the CS_HAFAILOVER connection property. Component Integration Services uses the ct_con_props() API to set this property, if the cis hafailover server option is true.