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).