Cannot uninstall SQL Server 2005

Last week one of the team members was finding it difficult to uninstall SQL Server 2005. It was failing due to missing .msi/.msp files and setup error log had these entries.

Local cached package 'C:\WINDOWS\Installer\7f6522.msi' could not be opened as a storage file.

Couldn't find local patch 'C:\WINDOWS\Installer\7f660a.msp'. Looking for it at its source.

I had posted on how to workaround these issues earlier. One of my fellow SMEs worked on this issue and with all the approvals in place, I am posting this here!

By going through the error logs, a list of files missing from the C:\Windows\Installer folder was created. Then these files were renamed after copying. The installation proceeded further but this time failed with a new error. Only the Database Engine was not getting un-installed.

Disallowing uninstallation of patch {14ED24FB-0FAF-4B76-82EB-EF6A2F79E62D}
because the patch is marked as not uninstallable

Product: Microsoft SQL Server 2005 (64-bit) - Update 'Service Pack 3 for SQL Server Database Services 2005 (64-bit) ENU (KB955706)'
could not be removed. Error code 1646.

The setup was failing because the SP3 for SQL Server 2005 was marked as Uninstallable! After trying lot of work around, Windows Regsitry was the last ray of hope. Hence navigated to the hive which had the product id

14ED24FB-0FAF-4B76-82EB-EF6A2F79E62D in it.

All the installed products will be under

The hive which had the product id mentioned above, had a key named Uninstallable and it had a value of 0.

Gotcha! This was causing the un-installer to fail. Quickly changed the value of Uninstallable to 1 and the Uninstaller completed successfully!

At the end it seemed to be “such a small thing” but on that day it took almost two hours to track this down.

2 thoughts on “Cannot uninstall SQL Server 2005

  1. Pingback: Add node fails with Attempted to read or write protected memory error - SQL Server - SQL Server - Toad World

Comments are closed.