Difference between revisions of "Upgrading SQL"

Revision as of 20:43, 20 July 2009

The following instructions are CRITICAL !!!

Windows XP users should read this entire article before attempting to apply SQL Server Express 2005 SP3 upgrade.

There is a known issue in the upgrade process of SQL Server Express 2005 SP3. Please follow the steps below to successfully perform the upgrade.

The Problem

The SQL Server Express installer will fail when it detects a current (or newer) version of MSXML 6.0. The solution is to remove the MSXML6.0 component before running the installation for SQL Server Express 2005 SP3.

This is the error that you will see when the SQL Server Express 2005 SP3 installation fails.

How to Upgrade to Microsoft SQL Express 2005 SP3

It is very important that the following instructions are executed in the proper order. Any deviation from these steps may cause further complications and difficulty repairing the SQL installation.

Use Microsoft Installer Cleanup Utility to Cleanup MSXML 6.0

• Download the Cleanup Utility here: http://support.microsoft.com/kb/290301
• Install and Run the Cleanup Utility
• Select MSXML6 Service Pack 2 (KB954459) [6.20.1099.0] in the list, and then click Remove.

Install Microsoft SQL Express 2005 SP3

At this point, you can run the DLS IV Auto Updater installation again. The DLS IV Auto Updater will automatically install SQL Server Express 2005 SP3. Or you can manually download it and install.

SQL Server Express 2005 SP3 is available for download here: http://www.microsoft.com/downloads/details.aspx?familyid=3181842A-4090-4431-ACDD-9A1C832E65A6

More Information

Read more information about this issue at the following locations

• Microsoft's official recommended recovery procedure: http://support.microsoft.com/kb/968749
• Google Group - SQL Installation Trouble: http://groups.google.com/group/flex-list/web/installation-problems-with-sql-server?pli=1