MSSQL_ENG020557

Applies to: SQL Server Azure SQL Managed Instance

Message Details

Attribute Value
Product Name SQL Server
Event ID 20557
Event Source MSSQLSERVER
Component SQL Server Database Engine
Symbolic Name
Message Text Agent shutdown. For more information, see the SQL Server Agent job history for job '%s'.

Explanation

A replication agent has shut down without writing a reason to the appropriate history table, or the agent was shut down while in the middle of a process.

User Action

  • Restart the agent to see whether 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 how to view agent status and error details in Replication Monitor, see View Information and Perform Tasks using Replication Monitor.

  • Verify that basic connectivity is working between the computers that are accessed by the agent, and then connect to each computer by using a utility, such as the sqlcmd utility. When you connect, use the same account under which the agent makes connections. For more information about the permissions that are required by each agent account, see Replication Agent Security Model.

  • If the error occurs while you are 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 additional error messages. For more information about how to configure logging for replication, see the Microsoft Knowledge Base article 312292.