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, sa
You can use set role to turn the role on or off for this session.
