Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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

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

View products that this article applies to.

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.

↑ Back to the top

Cause

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

↑ Back to the top

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:
    sys.syslanguages (Transact-SQL)
  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"

↑ Back to the top

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"

↑ Back to the top

Keywords: kb

↑ Back to the top

Article Info
Article ID : 2496344
Revision : 3
Created on : 11/20/2019
Published on : 11/20/2019
Exists online : False
Views : 321