Applies To: SQL Server 2016
|Product Name||SQL Server|
|Component||SQL Server Database Engine|
|Message Text||Replication-%s: agent %s failed. %s|
This error is raised for any replication agent failure. The text at the end of the message depends on the context of the failure.
This error can occur in a number of situations; use the following approaches as necessary:
Restart the failed agent to see if it will now run without failures. For more information, see Start and Stop a Replication Agent (SQL Server Management Studio) and Replication Agent Executables Concepts.
Check the agent history and job history for other errors that occurred around the same time. For information about viewing agent status and error details in Replication Monitor, see the following topics:
For the Snapshot Agent, Log Reader Agent, and Queue Reader Agent, see View Information and Perform Tasks for the Agents Associated With a Publication (Replication Monitor).
For the Distribution Agent and Merge Agent, see View Information and Perform Tasks for the Agents Associated With a Subscription (Replication Monitor).
Verify that basic connectivity is working between the computers accessed by the agent, and then connect to each computer with a utility like the sqlcmd Utility. When connecting, use the same account under which the agent makes connections. For more information about the permissions required by each agent account, see Replication Agent Security Model.
If the error occurs while creating or applying a snapshot, check the files in the snapshot directory for errors.
If the error continues to occur, increase the logging of the agent and specify an output file for the log. Depending on the context of the error, this could provide the steps leading up to the error and/or additional error messages.
Replication Agent Administration
Errors and Events Reference (Replication)
Replication Distribution Agent
Replication Log Reader Agent
Replication Merge Agent
Replication Queue Reader Agent
Replication Snapshot Agent