Mirror Replication Agent requires client access to the Replication Server to send replicated transactions.
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 mro_rs_user set password mro_rs_pwd
where:
mro_rs_user is the Mirror Replication Agent user login name.
mro_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 mro_rs_user
where mro_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).
