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: ResUtilsStartResourceServi ce 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.
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: ResUtilsStartResourceServi
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.
Verify both servers can see the cluster resources. The HD, the DB and even the HB connection between them.
ASKER
Yup, I have been able to successfully failover the cluster from one server to another with no problems.
Review the dependancies for the Agent.
ASKER
SQL Server (MSSQLSERVER)
Any information in the SQL log, could review the cluster as well for hints.
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.
The cluster log may list more info on what the issue is.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.