Mirror Replication Agent requires client access to the Replication Server to send replicated transactions.
If the Replication Server and databases were previously
configured for a Replication Server warm standby application, the Mirror Replication Agent can use
the Replication Server login that was created for the ASE RepAgent thread.
See “Converting a warm standby application to a Mirror Activator system” for
more information.
Use the following procedure to set up a Replication Server user login name for the Mirror Replication Agent instance.
You must have “sa” permission in the
Replication Server to perform this procedure.
To create a Replication Server user login for Mirror Replication Agent
Log in to the Replication Server with a login that has “sa” permission.
Create the Mirror Replication Agent user login name in the Replication Server:
create user mra_rs_user set password mra_rs_pwd
where:
mra_rs_user is the Mirror Replication Agent user login name.
mra_rs_pwd is the password for the user login name.
Grant connect source permission to the Mirror Replication Agent login name:
grant connect source to mra_rs_user
where mra_rs_user is the Mirror Replication Agent user login name.
After you set up the Mirror Replication Agent user login in the Replication Server, verify that the new user login name is valid (it can log in to the Replication Server).
