Friday, September 23, 2011

MS SQL Server 2008 R2 SP1 fails with error 84C4000E

Windows updates are fine, they make sure your system gets updated when needed.

Sometimes you get strange error numbers with the message that a update did fail.

Today we had a error 84C4000E when installing SP1 of SQL Express 2008R2 on a Windows 2008 Server.
Normaly google helps solving the problem, not (completely) this time:

The only reference to the error number I was able to find was:

http://social.msdn.microsoft.com/Forums/es-ES/sqlserveres/thread/05050d46-d6f9-41e4-8276-46750dabe88f


Spanish... ok, google helps translating....

So it turned down to the following issue:

  • Your windows server is installed/configured in a language not supported by SQL 2008R2
  • Such "wrong" combinations are for example German-Swiss and trying to install a German edition of SQL 2008R2 (Or aparently also some variants of spanish)

The simplest thing to solve this:
  • Just change your user locale from German-Swiss to German-Germany
  • Install the service pack
  • Change the user locale back to what is was previously

During installation we had similar problems and after some talk with MS support it did turn out that a German SQL Server 2008R2 can't be installed if the user locale was no German-Germany.
So changing it to the requested locale did the trick.

Strange enough, we later on wished to enter the product key... again the same problem and after more talk with MS support, changing the locale again did the trick...

According to MS support it should also be possible to change the locale to English-US and a german SQL Server should also be "installable"...

5 comments:

  1. Hi! I get the same error. How do you change the "user locale" and what is it exactly? Thank you very much for your help. Kind Regards Markus

    ReplyDelete
  2. hat bei mir nicht ganz geklappt, aber motiviert es zu versuchen. Ich habe den SP direkt runtergeladen und dann gestartet. Nur die Region umstellen hatte das Problem nicht gelöst.

    ReplyDelete
  3. Wäre doch schöm, wenn MS das Problem in den Griff kriegen würde.

    ReplyDelete
  4. Funktionierte nicht mit Umstellung des Gebietsschemas auf Deutsch-Deutschland. Musste auch SP1 runterladen und manuell installieren

    ReplyDelete
  5. Auch auf dem SBS2011 kommt der gleiche Fehler. Leider sind wir halt in der Schweiz und brauchen German-Swiss als Einstellung.
    Sehr mühsam, das MS so einen Fehler nicht endlich behebt!

    ReplyDelete