You receive a "This service pack is meant for a different language than your installed product" error message when you try to install a SQL Server 2000 service pack

Article translations Article translations
Article ID: 903003 - View products that this article applies to.
Expand all | Collapse all

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.

Properties

Article ID: 903003 - Last Review: August 19, 2005 - Revision: 1.2
APPLIES TO
  • Microsoft SQL Server 2000 Standard Edition
Keywords: 
kbtshoot kbinfo kbprb KB903003

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com