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 (903003)

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.