Setting Up the RSSD User Login for Replication Agent

Set up a user login name for the Replication Agent instance in an RSSD managed by Adaptive Server Enterprise.

Prerequisites

You must have a system administrator user role in the Adaptive Server Enterprise that manages the RSSD to perform this procedure.

Task

You can configure Replication Server to use an external Adaptive Server Enterprise database to host the RSSD information. By default, the Replication Server uses an embedded RSSD. If your environment requires that an Adaptive Server Enterprise must be used to host the RSSD, these instructions apply.

Log in to the Adaptive Server Enterprise that manages the RSSD.
Add the Replication Agent login name to the RSSD data server:
```
use master
sp_addlogin ra_rssd_user, ra_rssd_pwd, rssd_db
```
where:
- ra_rssd_user is the Replication Agent user login name.
- ra_rssd_pwd is the password for the user login name.
- rssd_db is the database name of the RSSD.
Add the Replication Agent user login name to the RSSD, and add the login name to the rs_systabgroup group:
```
use rssd_db
sp_adduser ra_rssd_user
sp_changegroup rs_systabgroup, ra_rssd_user
```
where:
- rssd_db is the database name of the RSSD.
- ra_rssd_user is the Replication Agent user login name.

After you set up the Replication Agent user login in the RSSD, verify that the new user login name is valid (it can log in to the RSSD data server and access the RSSD).