05 February 2017

Install SQL 2008 SP3 - Windows Update Error Code 84BE0BCE

When trying to install the SQL 2008 service pack 3(KB2979597) (or the security update KB3045316) through WSUS (on premise) you may encounter the following error:
















Windows Update Error Code 84BE0BCE, now this doesn't say anything useful so to the Google-O-Matic we go.
Many will suggest to install the SP3 manually, so after downloading the file and running the installer I got this:

















Not very useful as well...

Turns out there's a command line installation option with this (I never would have guessed I never do anything with SQL).
The option is to skip the cluster check like this:

C:\Temp\SQLServer2008R2SP3-KB2979597-x64-ENU.exe :\Setup /SkipRules=Cluster_IsOnlineIfClustered /action=patch

The same goes for KB3045316:

SQLServer2008R2-KB3045316-x64.exe :\Setup /SkipRules=Cluster_IsOnlineIfClustered /action=patch


And then you can install the SP3 without the error in the first screenshot because the cluster check rule is skipped.



2 comments:

  1. 5 years later this saved my day! Thanks for sharing this information :D

    ReplyDelete
  2. Anonymous15/8/22 14:52

    Same here, for Security Update for SQL Server 2016 Service Pack 3 GDR (KB5014355), which goes to show that Microsoft still don’t fix things. Note that if you get “The specified value for setting MEDIALAYOUT is invalid” instead, remove the mysterious “:\Setup” — not clear what that switch does (bypass UI?) but there is a suggestion that it is breaking the command line somehow.

    ReplyDelete