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.
Data server is running.
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, and execute this query using the Replication Server System Database (RSSD):

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

If you have password encryption, you cannot access the password by executing a query. If the maintenance user name or password is incorrect, change it on the data server or use alter connection to change it in Replication Server. 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 sysadmin log_first_tran 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.