Mirror Replication Agent requires client access to the primary database to acquire information about the database schema and database log devices, and to reserve the logscan context.
Use the following procedure to set up a user login name in the primary data server and the primary database for the Mirror Replication Agent instance.
You must have a System Administrator user role in the
primary Adaptive Server to perform this procedure.
To create a primary database user login for Mirror Replication Agent
Log in to the primary Adaptive Server with a System Administrator user role.
Add the Mirror Replication Agent login name to the primary data server:
use master sp_addlogin mra_pds_user, mra_pds_pwd, pdb
where:
mra_pds_user is the Mirror Replication Agent user login name.
mra_pds_pwd is the password for the user login name.
pdb is the name of the primary database.
Grant the Replication role to the Mirror Replication Agent login name:
grant role replication_role to mra_pds_user
where mra_pds_user is the Mirror Replication Agent user login name.
Add the Mirror Replication Agent user login name to the primary database:
use pdb sp_adduser mra_pds_user
where:
pdb is the name of the primary database.
mra_pds_user is the Mirror Replication Agent user login name.
After you set up the Mirror Replication Agent user login in the primary data server, verify that the new user login name is valid (it can log in to the primary data server and access the primary database).
