This error is raised for any replication agent failure.
The exact problem will depend on the context of the failure and can be found in Alert Description.
Follow these steps:
Restart the failed agent to see if it will now work.
The text at the Alert Description may help you to narrow down the problem. Search your available resources for the exact text after the word "failed."
Check the agent history for other errors around the same time that can help you to troubleshoot the failure.
Add a log to the failing replication agent. Depending on the context of the error, this may provide the steps leading up to the error and/or additional error messages. For more information about configuring a log for replication, see the Microsoft Knowledge Base article refered at the "External" section.
If the error occurs while creating or applying a snapshot, check the files in the snapshot directory for errors.
Verify that basic connectivity is working between the machines 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.
How to: Start and Stop a Replication Agent (SQL Server Management Studio)
Monitoring Replication with Replication Monitor
How to enable replication agents for logging to output files in SQL Server
Target | Microsoft.SQLServer.2008.DBEngine | ||
Category | EventCollection | ||
Enabled | False | ||
Alert Generate | True | ||
Alert Severity | Error | ||
Alert Priority | High | ||
Remotable | True | ||
Alert Message |
|
ID | Module Type | TypeId | RunAs |
---|---|---|---|
DS | DataSource | Microsoft.SQLServer.2008.EventProvider | Default |
GenerateAlert | WriteAction | System.Health.GenerateAlert | Default |
<Rule ID="Microsoft.SQLServer.2008.ReplicationAgentFailureRule" Target="SQL2008Core!Microsoft.SQLServer.2008.DBEngine" Enabled="false" ConfirmDelivery="true">
<Category>EventCollection</Category>
<DataSources>
<DataSource ID="DS" TypeID="Microsoft.SQLServer.2008.EventProvider">
<ComputerName>$Target/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$</ComputerName>
<PublisherName>$Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$</PublisherName>
<EventNumber>20536</EventNumber>
</DataSource>
</DataSources>
<WriteActions>
<WriteAction ID="GenerateAlert" TypeID="SystemHealth!System.Health.GenerateAlert">
<Priority>2</Priority>
<Severity>2</Severity>
<AlertMessageId>$MPElement[Name="Microsoft.SQLServer.2008.ReplicationAgentFailureRule.AlertMessage"]$</AlertMessageId>
<AlertParameters>
<AlertParameter1>$Data/EventDescription$</AlertParameter1>
</AlertParameters>
<Suppression>
<SuppressionValue>$Data/LoggingComputer$</SuppressionValue>
<SuppressionValue>$Data/PublisherName$</SuppressionValue>
<SuppressionValue>$Data/EventDisplayNumber$</SuppressionValue>
</Suppression>
</WriteAction>
</WriteActions>
</Rule>