Replication Server Login Name and Password for RepAgent

Learn the guidelines, commands, and procedures to change the Replication Server login name and password for RepAgent.

RepAgent retrieves information about changes to the replicated system tables in the RSSD or to the primary database from the database transaction logs and submits them to the Replication Server for distribution.

Replication Server needs a login name for RepAgent. The rs_init program uses the create user command to add this Replication Server user.

Observe these guidelines when you change the Replication Server login name and/or password for the RepAgent. The login name and password you create at the Replication Server must be the same as that used to configure the RepAgent at Adaptive Server.

At Replication Server:

To change the password, use the alter user command with the set password clause.
To change both the login name and password, use the drop user command to drop the old user login name and the create user command to create the new login and password. Then grant the user connect source permission.

At Adaptive Server:

To change the login name and password, use the sp_config_rep_agent system procedure with the dbname, rs_servername, rs_username, and rs_password options.

This updates the login name and password in the database sysattributes table. The password is always encrypted.
For the updates to take effect, restart RepAgent.

See Replication Server Reference Manual > Replication Server Commands > alter user and, Replication Server Reference Manual > Adaptive Server Commands and System Procedures > sp_config_rep_agent for syntax details.