Use the following procedure to set up a user login name for the Mirror Replication Agent instance in an RSSD managed by Adaptive Server.
You can configure Replication Server to use an external
Adaptive Server Enterprise database to host the RSSD information.
By default, the Replication Server for Mirror Activator uses an
embedded RSSD. If your environment requires that an ASE must be
used to host the RSSD, these instructions will apply.
You must have a System Administrator user role in the Adaptive Server that manages the RSSD to perform this procedure.
See “Setting up the ERSSD user login for Mirror Replication Agent” for information about setting
up a user login name for the Mirror Replication Agent instance in an ERSSD managed
by Adaptive Server® Anywhere.
To set up the RSSD user login for Mirror Replication Agent
Log in to the Adaptive Server that manages the RSSD with a System Administrator user role.
Add the Mirror Replication Agent login name to the RSSD data server:
use master sp_addlogin mro_rssd_user, mro_rssd_pwd, rssd_db
where:
mro_rssd_user is the Mirror Replication Agent user login name.
mro_rssd_pwd is the password for the user login name.
rssd_db is the database name of the RSSD.
Add the Mirror Replication Agent user login name to the RSSD:
use rssd_db sp_adduser mro_rssd_user
where:
rssd_db is the database name of the RSSD.
mro_rssd_user is the Mirror Replication Agent user login name.
After you set up the Mirror Replication Agent user login in the RSSD, verify that the new user login name is valid (it can log in to the RSSD data server and access the RSSD).
