DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 903003 - Last Review: August 19, 2005 - Revision: 1.2

SYMPTOMS

When you try to install a Microsoft SQL Server 2000 service pack, the installation may fail, and you receive the following error message:
This Service Pack is meant for a different language than your installed product
This problem may occur even if the language of the service pack is the same as the language of SQL Server 2000 that is installed on the computer.

MORE INFORMATION

SQL Server Setup for the service pack compares the language of the service pack to the language of SQL Server 2000 that is installed. How the Setup program for the service pack does this depends on which of the following options was selected during the setup of the original SQL Server 2000 installation:
  • Connectivity Only
    When only the Connectivity Only installation option was selected, the Setup program for the service pack verifies the language of the system in the regional settings. To verify the current language, follow these steps:
    1. Click Start, click Control Panel, and then click Regional and Language Options.
    2. In the Regional and Language Options dialog box, click the Advanced tab. The current language is displayed.
  • Client Tools Only
    When only the Client Tools Only installation option was selected, a DWORD registry entry that is named DefClientOnlyInstalled is set to 1 in the following registry subkey:
    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\80\Tools
    Therefore, the Setup program for the service pack checks for this registry entry. Then, the Setup program for the service pack compares the language of the service pack to the Language DWORD registry entry that is located in the following registry subkey:
    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\80\Tools\ClientSetup\CurrentVersion
  • Server and Client Tools
    When the Server and Client Tools installation option was selected, the Setup program for the service pack compares the language of the service pack to the Language DWORD registry entry that is located in the following registry subkey for a SQL Server default instance:
    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\CurrentVersion
    For a SQL Server named instance, the Language DWORD registry entry is located in the following registry subkey:
    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\<InstanceName>\MSSQLServer\ClientSetup\CurrentVersion
Note You can determine the language of the Setup program for the service pack by checking the Setupsql.exe file version information.

APPLIES TO
  • Microsoft SQL Server 2000 Standard Edition
Keywords: 
kbtshoot kbinfo kbprb KB903003
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support