Asynchronous transaction connection failures

When an asynchronous stored procedure reaches the primary Replication Server, the 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. See “Examining the exceptions log” for more information.