Issue while installing SP1 on a SQL 2008 R2 Cluster–Resolved

Came across this odd issue yesterday while patching a SQL 2008 R2 failover cluster. After moving over all the services to the passive node the service pack failed to install on two out of three instances. The instance that worked was an Analysis Services instance the other two that failed were Database Engine instances.

After a another reboot and further patching attempt I poked around Failover Cluster Manager and wouldn’t you know it, The Cluster Name was offline.

Once I brought it online, Service Pack 1 went on fine. If only the Service Pack Installer spotted that, could have saved me a few worried minutes!

image

Overall Summary Contents

Instance InstanceName overall summary:

Final result: The patch installer has failed to update the shared features. To determine the reason for failure, review the log files.

Exit code (Decimal): -595541211

Exit facility code: 1152

Exit error code: 49957

Exit message: The patch installer has failed to update the shared features. To determine the reason for failure, review the log files.

Start time: 2011-11-13 12:22:06

End time: 2011-11-13 12:23:12

Requested action: Patch

Log with failure: C:Program FilesMicrosoft SQL Server100Setup BootstrapLog20111113_121410InstanceNameDetail.txt

Exception help link: http%3a%2f%2fgo.microsoft.com%2ffwlink%3fLinkId%3d20476%26ProdName%3dMicrosoft%2bSQL%2bServer%26EvtSrc%3dsetup.rll%26EvtID%3d50000%26ProdVer%3d10.50.2500.0%26EvtType%3d0xBF50B949%400xDC80C325

Details.txt Contents

The first error I found was “The RPC server is unavailable”. After that error, several more errors were logged but the RPC server error is where it all started.

 

2011-11-13 13:42:25 Slp: Sco: Attempting to write hklm registry key SOFTWAREWow6432NodeMicrosoftWindowsCurrentVersionUninstall to file C:Program FilesMicrosoft SQL Server100Setup BootstrapLog20111113_133842InstanceNameRegistry_SOFTWARE_Wow6432Node_Microsoft_Windows_CurrentVersion_Uninstall.reg_

 

2011-11-13 13:42:25 Slp: Sco: Attempting to write hklm registry key SOFTWAREWow6432NodeMicrosoftMSSQLServer to file C:Program FilesMicrosoft SQL Server100Setup BootstrapLog20111113_133842InstanceNameRegistry_SOFTWARE_Wow6432Node_Microsoft_MSSQLServer.reg_

 

2011-11-13 13:42:25 Slp: The RPC server is unavailable

 

2011-11-13 13:42:26 Slp: Watson bucket for exception based failure has been created

 

2011-11-13 13:42:26 Slp: Error: Action "SqlEngineConfigAction_patch_configrc_Cpu64" failed during execution.

 

2011-11-13 13:42:28 Slp: Error result: -595541211

2011-11-13 13:42:28 Slp: Result facility code: 1152

2011-11-13 13:42:28 Slp: Result error code: 49957

2011-11-13 13:42:28 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine

2011-11-13 13:42:28 Slp: Sco: Attempting to open registry subkey

2011-11-13 13:42:28 Slp: Sco: Attempting to open registry subkey SoftwareMicrosoftPCHealthErrorReportingDWInstalled

2011-11-13 13:42:28 Slp: Sco: Attempting to get registry value DW0201

2011-11-13 13:42:28 Slp: Submitted 1 of 1 failures to the Watson data repository

Senior consultant and company director at The Full Circle. Passionate about automation scripting, end user experience and cloud technology.