Thursday, May 31, 2007

SQL Server 2005 Cannot Uninstall due to IIsMimeMap

Today I was trying to remove and reinstall an SQL Server 2005 installation from one of my servers. This resulted in the following error

The setup failed to read IIsMimeMap table. The error code is -2147024893

I did some search on the net and this MSDN Post had the answer.

The main cause of this is that there is some interaction with the IIS with the Reporting Service in the SQL server 2005 installation.

It is actually easy to work around this issue.

  • Go to the service control panel.
  • Find IIS Administrator
  • Disable the service and stop it.
  • Uninstall the SQL 2005 (by now the only remenant is the uninstalled Reporting service).

That will work.

No comments: