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.
You can set up remote servers for failover after performing these configuration steps:
Enable new server option cis hafailover:
exec sp_serveroption server_name, ’cis hafailover’, true
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, as shown in this example:
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.
