The primary Replication Server logs in to the replicate Replication Server using the RSI login name and password. The RSI user login name and password are created by rs_init and are also required when you create a route to the replicate Replication Server.
If there is a problem with the login name and password at the replicate Replication Server, the primary Replication Server logs one of these errors:
Jan 20 09:44:45.656 1993: Error: 1337, Line: 1978, File: ’/generic/useful/cm.c’- When trying to connect to server ’Rep_server’ as user ’Rep_server_RSI’, the DB-Library routine ’dbopen’ returned the error ’Error: 20014, Severity: 2 -- ’Login incorrect.’’. The server error message is ’Message: 1421, State: 0, Severity: 11 -- ’Invalid login attempted by user ’Rep_server_RSI’’’.
To repair this problem:
Retrieve the RSI user login name and password from the RSSD of the primary Replication Server by using isql to execute this query on the RSSD:
select username, password from rs_maintusers, rs_sites where name = remote_RS_name and destid = id
remote_RS_name is the destination Replication Server’s name.
id is the destination Replication Server’s site ID.
If you have password encryption, you cannot access the password by executing a query.
Perform one of these actions:
Use the alter route command to change the password for the primary Replication Server to the RSI user password, which you retrieved in the previous step.
Use the alter user command to change the password for the login name at the replicate Replication Server. Then use the resume route command to resume the route.
