Use the following procedure to set up a user login name for the Replication Agent instance in an RSSD managed by Adaptive Server.
You can configure Replication Server to use an external
Adaptive Server® Enterprise (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 Replication Agent” for more information.
To set up the RSSD user login for Replication Agent
Log in to the Adaptive Server that manages the RSSD with a System Administrator user role.
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:
use rssd_db sp_adduser 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).
