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.
Refer to Chapter 3, “Replication Server Commands,” and Chapter 5, “Adaptive Server Commands and System Procedures,” in the Replication Server Reference Manual for syntax details.
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.
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.
