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!
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
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.