Creating a Replication Server User Login for Replication Agent
Replication Agent requires client access to the
primary Replication Server to send replicated transactions.
Prerequisites
You must have sa permission
in the Replication Server to perform this procedure.
Task
To set up a Replication Server user login
name for the Replication Agent instance:
Log in to the Replication Server with a login
that has “sa” permission.
In the
Replication Server, create the Replication Agent user login name:
create user ra_rs_user set password ra_rs_pwd
where:
ra_rs_user is
the Replication Agent user login name.
ra_rs_pwd is
the password for the user login name.
Grant connect
source permission to the Replication Agent login name:
grant connect source to ra_rs_user
where ra_rs_user is
the Replication Agent user login name.
After you set up the Replication Agent user login in the primary
Replication Server, verify that the new user login name is valid
(it can log in to the Replication Server).