SQL Server Agent fails to start in Failover cluter

Posted on

Question :

The SQL server agent in a cluster (as a cluster resource) fails to start. I’m looking for error logs to give me a clue, but so far, all it says is: “failed to start”. What could be the possible issues? Where can I see a more detailed error log?

Update: I’ve checked the sql server logs, the cluster event logs and the windows event logs.

Answer :

There are logs in a few places. For the Agent logs please see the screenshot:

Agent Logs

In Object Explorer expand SQL Server Agent Error Logs.

Leave a Reply

Your email address will not be published. Required fields are marked *