Use the following procedure to set up a user login name for the Mirror Replication Agent instance in an RSSD managed by Adaptive Server Enterprise.
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.
You must have a System Administrator user role in the
Adaptive Server that manages the RSSD to perform this procedure.
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 mra_rssd_user, mra_rssd_pwd, rssd_db
where:
mra_rssd_user is the Mirror Replication Agent user login name.
mra_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 mra_rssd_user
where:
rssd_db is the name of the primary database.
mra_rssd_user is the Mirror Replication Agent user login name.
After you set up the Mirror Replication Agent user login in the RSSD data server, verify that the new user login name is valid (it can log in to the RSSD data server and access the RSSD).
