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
You must log out and then log back in to the Adaptive Server for the change to take effect.
