Take the 2-minute tour ×
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. It's 100% free, no registration required.

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
add comment

1 Answer 1

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
add comment

Your Answer

 
discard

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.