Link to home
Start Free TrialLog in
Avatar of nvr8981
nvr8981

asked on

Unable to bring up SQL Server Agent in SQL Cluster

The cluster is built with 2 boxes with Windows Server 2003 Ent. R2 SP2 x64, connected to a Promise Technology fiber channel box.  I was doing some testing last night with our SQL cluster to make sure it was redundant.  I pulled out one too many HDD and broke the cluster.  I got the majority of it back, however I still can't bring up the SQL Server Agent from the Cluster Administrator, the SQL Configuration, or Windows Services.  Here are the errors I get when I try to bring the Agent back up:

Event Type:      Error
Event Source:      SQLSERVERAGENT
Event Category:      Failover
Event ID:      53
Date:            3/27/2008
Time:            9:05:21 AM
User:            N/A
Computer:      NJDBCL1
Description:
[sqagtres] StartResourceService: Failed to start SQLSERVERAGENT service.  CurrentState: 1


For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 35 00 00 40 01 00 00 00   5..@....
0008: 05 00 00 00 41 00 58 00   ....A.X.
0010: 44 00 42 00 00 00 00 00   D.B.....
0018: 00 00                     ..      

Event Type:      Error
Event Source:      SQLSERVERAGENT
Event Category:      Failover
Event ID:      53
Date:            3/27/2008
Time:            9:05:21 AM
User:            N/A
Computer:      NJDBCL1
Description:
[sqagtres] OnlineThread: ResUtilsStartResourceService failed (status 435)


For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 35 00 00 40 01 00 00 00   5..@....
0008: 05 00 00 00 41 00 58 00   ....A.X.
0010: 44 00 42 00 00 00 00 00   D.B.....
0018: 00 00                     ..      

Event Type:      Error
Event Source:      SQLSERVERAGENT
Event Category:      Failover
Event ID:      53
Date:            3/27/2008
Time:            9:05:21 AM
User:            N/A
Computer:      NJDBCL1
Description:
[sqagtres] OnlineThread: Error 435 bringing resource online.


For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 35 00 00 40 01 00 00 00   5..@....
0008: 05 00 00 00 41 00 58 00   ....A.X.
0010: 44 00 42 00 00 00 00 00   D.B.....
0018: 00 00                     ..      

If anyone can help me out with this, it would be greatly appreciated.  I really don't want to reinstall the Cluster and the SQL database.
Avatar of shniz123
shniz123
Flag of United States of America image

Verify both servers can see the cluster resources. The HD, the DB and even the HB connection between them.
Avatar of nvr8981
nvr8981

ASKER

Yup, I have been able to successfully failover the cluster from one server to another with no problems.
Avatar of 65td
Review the dependancies for the Agent.
Avatar of nvr8981

ASKER

SQL Server (MSSQLSERVER)
Any information in the SQL log, could review the cluster as well for hints.
Avatar of nvr8981

ASKER

Just what I posted in the initial description.
So the cluster group moves between nodes with no issues and SQL the same except for the SQL Agent correct?

The cluster log may list more info on what the issue is.
ASKER CERTIFIED SOLUTION
Avatar of nvr8981
nvr8981

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial