debugsqlMinor
SQL Server Agent fails to start in Failover cluter
Viewed 0 times
failssqlagentcluterfailoverstartserver
Problem
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.
Update: I've checked the sql server logs, the cluster event logs and the windows event logs.
Solution
There are logs in a few places. For the Agent logs please see the screenshot:
In Object Explorer expand SQL Server Agent \ Error Logs.
In Object Explorer expand SQL Server Agent \ Error Logs.
Context
StackExchange Database Administrators Q#22666, answer score: 4
Revisions (0)
No revisions yet.