Connection Failure to the Database

Troubleshoot connection failures.

If the error is a connection failure to the database:

Verify that the data server is defined in the interfaces file.
Verify that the data server is running.
Verify that the maintenance user name and password are correct.

To find the maintenance user name and password for a database, log in to the system Adaptive Server, use the Replication Server System Database (RSSD), and execute the following query:

select username, password
     from rs_maintusers, rs_databases
     where destid = dbid
     and dsname = data_server
    and dbname = database

If the maintenance user name or password is not correct, you can either change them on the data server or use the alter connection command to change them in the Replication Server. If you have password encryption, you cannot access the password by executing a query. After correcting the user name or password, resume the connection.

Asynchronous Transaction Connection Failures

When an asynchronous stored procedure reaches the primary Replication Server, the Data Server Interface (DSI) uses the original login and password to connect to the primary data server. The maintenance login is not used.

If the login fails, use the sysadmin log_first_tran command to log the asynchronous transaction into the exceptions log. The app_user and app_pwd columns in the rs_exceptshdr system table contain the login and password the DSI uses to log in to the primary data server.