You may not be able to apply SQL Server 2000 64-bit post SP4 hotfix build 8.0.2156 or a later build after you use Windows Installer 2.0 to apply a SQL Server 2000 post SP4 hotfix that is earlier than build 8.0.2155 (911303)

SYMPTOMS

After you use Microsoft Windows Installer 2.0 to apply a Microsoft SQL Server 2000 post Service Pack 4 (SP4) hotfix that is earlier than build 8.0.2156, you may not be able to apply SQL Server 2000 post SP4 build 8.0.2156 or a later build. Typically, this problem occurs when the following conditions are true:

You apply the hotfix on a computer that is running SQL Server 2000 SP4 64-bit.
You have applied any hotfix between build 8.0.2141 and build 8.0.2155.

When you experience this problem, the following error messages are logged in the SQL64_Hotfix_KBxxxxxx_sqlrun.msp_0.log file:

MSI (s) (A8:E8) [Time]: Disallowing uninstallation of patch {2B8A100C-ED6E-439C-915D-B37169259B94} because it was not applied with MSI 3.0
MSI (s) (A8:E8) [Time]: Product: Microsoft SQL Server Enterprise Edition (64-bit) - Update '{2B8A100C-ED6E-439C-915D-B37169259B94}' could not be removed. Error code 1646. Additional information is available in the log file C:\WINDOWS\Hotfix\SQL64\Logs\SQL64_Hotfix_KBxxxxxx_sqlrun.msp.log.
MSI (s) (A8:E8) [Time]: Product: Microsoft SQL Server Enterprise Edition (64-bit) - Update '{6F25BA24-83DC-410A-B153-48915753A527}' could not be installed. Error code 1646. Additional information is available in the log file C:\WINDOWS\Hotfix\SQL64\Logs\SQL64_Hotfix_KBxxxxxx_sqlrun.msp.log.
MSI (s) (A8:E8) [Time]: Product: Microsoft SQL Server Enterprise Edition (64-bit) Product: Microsoft SQL Server Enterprise Edition (64-bit) -- Installation failed.

Note This problem does not occur on servers that are running SQL Server 2000 32-bit versions.

CAUSE

This problem occurs when you use Windows Installer 2.0 to apply one or more SQL Server 2000 builds that are later than build 8.0.2141 and earlier than build 8.0.2156. After you upgrade to Windows Installer 3.0, hotfix builds may not be able to detect and remove builds between 8.0.2141 and 8.0.2155 before you can apply hotfix builds that are later than 8.0.2155.

Note Microsoft Windows Server 2003 Service Pack 1 (SP1) installs Windows Installer 3.0. However, Windows Server 2003 and Microsoft Windows 2000 without the Windows Installer 3.0 redistributable package installs Windows Installer 2.0.

WORKAROUND

To work around this problem, follow these steps:

Extract the hotfix package by clicking the self-extracting executable file.

Note Do not install this hotfix package.
Copy all extracted files and subfolders to another location, such as DriveLetter:\Path.
Locate the Hotfix1.inf file in the DriveLetter:\Path folder.
Open the Hotfix1.inf file in Notepad.
In the Hotfix1.inf file, remove the line that contains the following parameter:
```
RemovePatches=
```
Save the modified Hotfix1.inf file.
Run Hotfix.exe from the DriveLetter:\Path folder.