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:
In Object Explorer expand SQL Server Agent Error Logs.