Use the following procedure to set up a Replication Server user login name for the Mirror Replication Agent instance.
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
Chapter 1 of the Mirror Replication Agent Primary Database Guide.
Mirror Replication Agent requires client access to the Replication Server to send replicated transactions.
You must have “sa” permission
in the Replication Server to perform this procedure.
Creating 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 ma_rs_user set password ma_rs_pwd
where:
ma_rs_user is the Mirror Replication Agent user login name.
ma_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 ma_rs_user
where ma_rs_user is the Mirror Replication Agent user login name.
Grant create object permission, which is required for generating replication definitions, to the Mirror Replication Agent login name:
grant create object to ma_rs_user
where ma_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).
