Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question
Can you specify what logs you have checked so far? – Mr.Brownstone Aug 17 '12 at 8:49
Does it always fail to start, or does it eventually start? – mrdenny Aug 18 '12 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 Dec 23 '12 at 5:38

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.

share|improve this answer
Not seeing the screenshot, uploaded twice. Hmmm. – Eric Higgins Aug 17 '12 at 16:31

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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