I have a SQL Server R2 cluster on Windows 2008 R2 boxes, and today i was to install SP3. I installed it without any errors and rebooted the passive node.
When i then try to failover to the passive node it fails. I get this from the Log
Log Name: Application
Source: MSSQLSERVER
Date: 2015-03-24 18:38:45
Event ID: 19019
Task Category: Failover
Level: Error
Keywords: Classic
User: N/A
Computer: computername.domain.se
Description:
[sqsrvres] OnlineThread: SQLClusterResourceWorkerWaitForCompletion failed (status 0)
Event Xml:
19019
2
3
0x80000000000000
16109747
Application
computername.domain.se
[sqsrvres] OnlineThread: SQLClusterResourceWorkerWaitForCompletion failed (status 0)
4B4A0040010000000D0000005700460041004C0049005400450043004C00300031003400000000000000
Log Name: System
Source: Microsoft-Windows-FailoverClustering
Date: 2015-03-24 18:38:45
Event ID: 1205
Task Category: Resource Control Manager
Level: Error
Keywords:
User: SYSTEM
Computer: computername.domain.se.se
Description:
The Cluster service failed to bring clustered service or application 'Computername' completely online or offline. One or more resources may be in a failed state. This may impact the availability of the clustered service or application.
Event Xml:
1205
0
2
3
0
0x8000000000000000
369312
System
computername.domain.se.se
computername
If i failback to the unpatched node, i get the resorces online without problem. But the patched node just keep on failing.
Does anybode have an idea on where i should start diggning?