MSSQL_ENG014151
Message Details
Product Name |
SQL Server |
Product Version |
9.0 |
Product Build Number |
9.00.1399.60 |
Event ID |
14151 |
Event Source |
MSSQLSERVER |
Component |
SQL Server Database Engine |
Symbolic Name |
|
Message Text |
Replication-%s: agent %s failed. %s |
Explanation
This error is raised for any replication agent failure. The text at the end of the message depends on the context of the failure.
User Action
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 How to: Start and Stop a Replication Agent (SQL Server Management Studio) and Programming Replication Agent Executables.
- 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 How to: View Information and Perform Tasks for the Agents Associated With a Publication (Replication Monitor).
- For the Distribution Agent and Merge Agent, see How to: 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. For more information, see Replication Agents (Troubleshooting).
See Also
Concepts
Cause and Resolution of Replication Errors
Other Resources
Administering Replication Agents
Replication Distribution Agent
Replication Log Reader Agent
Replication Merge Agent
Replication Queue Reader Agent
Replication Snapshot Agent