To set up Adaptive Server for an active-passive configuration, you must set the enable HA configuration parameter to 2. By default, enable HA is set to 0.
To set enable HA to 2, enter:
sp_configure "enable HA", 2
You must restart Adaptive Server for this parameter to take effect.
See the System Administration Guide: Volume 1 for information about enabling configuration parameters.