A Replication Agent sends data to Replication Server. Replication Agent logs in to the Replication Server, connects to the Replication Agent User thread of a Replication Server connection, and communicates with Replication Server over that connection. This has the following implications:
A valid user ID, which the Replication Agent uses to log in to the Replication Server, must be defined at the Replication Server.
The Replication Agent user ID must be granted connect source permission in Replication Server. connect source permission allows the Replication Agent to send commands that are valid only on a Replication Agent User thread.
The Replication Agent must record this user ID and associated password.
The Replication Agent must record the server and database portions of the Replication Server connection definition to identify and connect to the correct Replication Agent User thread.
The user_name and password defined in the Replication Server create connection command must be
The Replication Agent validates that the connection user_name exists in the primary database. However, Replication Server does not know if (or when) a DSI thread will be used. Therefore, the user ID and password must be valid in case the DSI thread is active.
The requirement for a valid primary database user ID
varies by Replication Agent. Some Replication Agents do not require
(nor do they check for) a valid user ID on the Replication Server
connection.
