SQL Server Installation Center may display English content on a localized version of SQL Server after you apply a cumulative update

Applies to: SQL Server 2008 DeveloperSQL Server 2008 EnterpriseSQL Server 2008 Express

Symptoms


After you apply a cumulative update on a localized (non-English) version of Microsoft SQL Server 2008 or of Microsoft SQL Server 2008 R2, SQL Server Installation Center may display English content instead of localized content.

Note The issue does not affect any other functionality of SQL Server.

Cause


Microsoft has confirmed that this is a problem in all updates for the Microsoft products that are listed in the "Applies to" section.

Resolution


To resolve this problem, follow these steps:
  1. Obtain the cumulative update package that matches your system architecture. For example, if you experience this issue after you install Cumulative Update 1 for SQL Server 2008 Service Pack 2 on a 64-bit system, you should obtain Cumulative Update 1 x64 for SQL Server 2008 Service Pack 2.

    Note If you still have a saved version of the package that you obtained from Support, you can directly go to step 2.
  2. Extract the contents of the package to a temporary folder (for example, C:\CU1) by running a command that resembles the following: 
    SQLServer2008-KB2289254-x64.exe /x:C:\CU1

    Note This command extracts Cumulative Update 1 for SQL Server 2008 Service Pack 2 package to a drive C folder that is named CU1.
  3. Find the Database Engine message group ID for your locale by referring to the "Installed languages" table in the following Books Online topic:
  4. Copy the necessary files to localize SQL Server Installation Center by running the following two commands:
    ROBOCOPY "<Extracted folder at step 2>\<your platform:x86 or x64>\<Database Engine message group ID>" "C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Release\x64\<Database Engine message group ID>"

    ROBOCOPY "<Extracted folder at step 2>\<your platform:x86 or x64>\<Local Language Identifier>" "C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Release\x64\<Local Language Identifier>"

    For example, if you are currently running the Japanese version of SQL Server 2008 Service Pack 2 on a 64-bit system, you should run the following commands:

    ROBOCOPY "C:\CU1\x64\1041" "C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Release\x64\1041"

    ROBOCOPY "C:\CU1\x64\ja" "C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Release\x64\ja"

More Information


For SQL Server 2008 R2, the directory path that you should use in the commands in step 4 in the "Resolution" section is as follows:

C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\SQLServer2008R2\<your platform:x86 or x64>\<Local Language Identifier>

For example:

SQL Server 2008
C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Release\x64\ja

SQL Server 2008 R2
C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\SQLServer2008R2\x64\ja

You can perform a ROBOCOPY operation on SQL Server 2008 R2 to fix a problem, as in the following example.,

Note You can perform the ROBOCOPY operation on SQL Server 2008 R2 only one time. However, you must perform the ROBOCOPY operation two times on SQL Server 2008. 

ROBOCOPY "C:\CU1\x64\ja" "C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Release\x64\ja"