Setting up the RSSD user login for Mirror Replication Agent

Use the following procedure to set up a user login name for the Mirror Replication Agent instance in an RSSD managed by Adaptive Server.

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

You must have a system administrator user role in the Adaptive Server that manages the RSSD to perform this procedure. See “Setting up the ERSSD user login for Mirror Replication Agent” for more information.

Using a system administrator user role, log in to the Adaptive Server that manages the RSSD.
Add the Mirror Replication Agent login name to the RSSD data server:
```
use master
sp_addlogin ma_rssd_user, ma_rssd_pwd, rssd_db
```
where:
- ma_rssd_user is the Mirror Replication Agent user login name.
- ma_rssd_pwd is the password for the user login name.
- rssd_db is the database name of the RSSD.
Add the Mirror Replication Agent user login name to the RSSD, and add the login name to the rs_systabgroup group:
```
use rssd_db
sp_adduser ma_rssd_user
sp_changegroup rs_systabgroup, ma_rssd_user
```
where:
- rssd_db is the database name of the RSSD.
- ma_rssd_user is the Mirror Replication Agent user login name.

After you set up the Mirror 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).