Assigning ha_role to the System Administrator

You must have the ha_role on both Adaptive Servers to run sp_companion. To assign the ha_role, issue the following from isql:

sp_role "grant", ha_role, user_name

Log out and then log back in to the Adaptive Servers for the change to take effect.