4

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.

Improve this question
3
  • Can you specify what logs you have checked so far?
    – Mr.Brownstone
    Commented Aug 17, 2012 at 8:49
  • Does it always fail to start, or does it eventually start?
    – mrdenny
    Commented Aug 18, 2012 at 2:24
  • Also, does the Agent fail to start on both (all) nodes in the cluster, or only one certain ones? Has the SQL Agent ever started successfully in this clustered instance?
    – SqlRyan
    Commented Dec 23, 2012 at 5:38

1 Answer 1

Reset to default
4

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.

Improve this answer
1
  • Not seeing the screenshot, uploaded twice. Hmmm.
    – Eric Higgins
    Commented Aug 17, 2012 at 16:31

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.