locked
SQL Server 2008 Agent Fails to start in a Win 2008 Cluster RRS feed

  • Question

  • When I try to bring SQLAGENT Online, I get the following errors:

    EventID:53

    [sqagtres] StartResourceService: Failed to start SQLSERVERAGENT service.  CurrentState: 1

    [sqagtres] OnlineThread: ResUtilsStartResourceService failed (status 435)

    [sqagtres] OnlineThread: Error 435 bringing resource online.

     

    I just did a fresh SQL Cluster install as well.  When I installed the cluster, the service account was good to go.  I cant figure out what is going on.  SQL Server Engine starts fine.  Any ideas?

    Tuesday, June 1, 2010 7:53 PM

Answers

  • When I try to bring SQLAGENT Online, I get the following errors:

    EventID:53

    [sqagtres] StartResourceService: Failed to start SQLSERVERAGENT service.  CurrentState: 1

    [sqagtres] OnlineThread: ResUtilsStartResourceService failed (status 435)

    [sqagtres] OnlineThread: Error 435 bringing resource online.

     

    I just did a fresh SQL Cluster install as well.  When I installed the cluster, the service account was good to go.  I cant figure out what is going on.  SQL Server Engine starts fine.  Any ideas?

    Never mind, It was permissions to the drive.
    • Marked as answer by Badpig Tuesday, June 1, 2010 8:25 PM
    Tuesday, June 1, 2010 8:23 PM

All replies

  • When I try to bring SQLAGENT Online, I get the following errors:

    EventID:53

    [sqagtres] StartResourceService: Failed to start SQLSERVERAGENT service.  CurrentState: 1

    [sqagtres] OnlineThread: ResUtilsStartResourceService failed (status 435)

    [sqagtres] OnlineThread: Error 435 bringing resource online.

     

    I just did a fresh SQL Cluster install as well.  When I installed the cluster, the service account was good to go.  I cant figure out what is going on.  SQL Server Engine starts fine.  Any ideas?

    Never mind, It was permissions to the drive.
    • Marked as answer by Badpig Tuesday, June 1, 2010 8:25 PM
    Tuesday, June 1, 2010 8:23 PM
  • What drive did you have to modify permissions on?  The clustered disk or the drive SQL is installed on?  What permissions did the Service Account need?
    Monday, August 30, 2010 6:46 PM
  • Hi Brian,

    Please check the permissions of the account running the SQL Agent Service and ensure that it has permissions to the right folders where the SYSTEM DB and Error LOG resides. Try to provide R/W permissions to account running SQL Agent on folder where these files resides.

     

     


    Regards Gursethi Blog: http://ms-gursethi.blogspot.com/
    Tuesday, August 31, 2010 4:25 AM