Home : SQL Server 2005 setup fails when MSXML Core Services 6.0 Service Pack 2 has already been installed during the installation of Hach WIMS 7.x
Q12184 - KNOWNISSUE: SQL Server 2005 setup fails when MSXML Core Services 6.0 Service Pack 2 has already been installed during the installation of Hach WIMS 7.x

This is taken from http://support.microsoft.com/kb/968749

SQL Server 2005 setup fails when MSXML Core Services 6.0 Service Pack 2 has already been installed

Consider the following scenario:

  • You have a Windows XP-based computer on which you apply the update for Microsoft XML Core Services (MSXML) 6.0 that is described in the following Microsoft Knowledge Base article:

    954459  (http://support.microsoft.com/kb/954459/ ) MS08-069: Description of the security update for XML Core Services 6.0: November 11, 2008
  • After you apply this MSXML update, you upgrade the computer to Windows XP Service Pack 3 (SP3).

When you try to install Microsoft SQL Server 2005 in this scenario, you receive the following error message:

Installation of MSXML 6 Service Pack 2 (KB954459) failed because a higher version already exists on the machine. To proceed, uninstall the higher version and then run MSXML 6 Service Pack 2 (KB954459) Setup again.

The screen shot of this error is as follows:

If you examine the SQL Server setup log file, you find that the following error has been logged:

This package is not supported on this operating system.
SkipInstallCA. Return value 3.

Fatal error during installation
MainEngineThread is returning 1603

Error code 1603
Product: MSXML 6.0 Parser (KB933579)
Installation failed.

If you examine the MSXML setup log file, you may find that the following error has been logged:

Action start Time: SkipInstallCA.
This package is not supported on this operating system.
Action ended Time: SkipInstallCA. Return value 3.
Action ended Time: INSTALL. Return value 3.
……
MSI (s) (9C:00) [Time]: Note: 1: 1729
MSI (s) (9C:00) [Time]: Product: MSXML 6 Service Pack 2 (KB954459) -- Configuration failed. ……
MSI (s) (A0:D0) [Time]: Note: 1: 1708
MSI (s) (A0:D0) [Time]: Product: MSXML 6 Service Pack 2 (KB954459) -- Installation failed.


You can find the setup log files in the following folder:
%WINDIR%\Program Files\Microsoft SQL Server\90\Setup Bootstrap\Log
Note This issue affects all editions and releases of SQL Server 2005.

CAUSE:

When SQL Server Setup tries to install MSXML 6.0 SP2, it detects that the version of MSXML 6.0 that is described in Knowledge Base article 954459 is already installed on the computer. Therefore, the validation process indicates that the current version of MSXML 6.0 should not be replaced. This stops the installation of both MSXML 6.0 and SQL Server 2005.

WORKAROUND:

To work around this issue, use the Windows Installer CleanUp utility to remove references to MSXML 6.0 Service Pack 2. To do this, follow these steps:
  1. Download the Windows Installer CleanUp utility. To do this, visit the following Microsoft Web site:
    http://support.microsoft.com/kb/290301 (http://support.microsoft.com/kb/290301)
  2. Run the Windows Installer CleanUp utility.
  3. Select MSXML6 Service Pack 2 (KB954459) [6.20.1099.0] in the list, and then click Remove.

  1. Install SQL Server 2005.
Note The Windows Installer CleanUp utility will not roll back the MSXML binaries to a previous version.

MORE INFORMATION:

After you run the Windows Installer CleanUp utility to remove MSXML6 SP2, the entry MSXML 6.0 Parser is removed from the Add or Remove Programs list in Control Panel. After you install SQL Server 2005, the MSXML 6.0 Parser entry reappears. This is the expected behavior.

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section


APPLIES TO

  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Standard X64 Edition
  • Microsoft SQL Server 2005 Standard Edition for Itanium-based Systems
  • Microsoft SQL Server 2005 Enterprise X64 Edition
  • Microsoft SQL Server 2005 Enterprise Edition for Itanium-based Systems
  • Microsoft SQL Server 2005 Workgroup Edition
  • Microsoft SQL Server 2005 Express Edition
  • Microsoft SQL Server 2005 Express Edition with Advanced Services

 

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
This is the only fix that actually worked. Microsoft provided a vb script but it didnt fix the problem. Luckily I already had an old copy of the Windows Installer Cleanup Utility. Approved: 12/1/2010 10:34 AM
Windows Installer CleanUp utility is no longer available. There seems to be no other work-around. So, am NOT able to install SQL Server 2005. Approved: 9/30/2010 6:48 AM
Dreadful. I followed your advice in order to uninstall MSXML6 SP2 and the "Fix It" program completely uninstalled every single Microsoft Office component I have on my PC. Considering this machine is a company machine, and was delivered to me with Office installed, I dont have the installation media. This will cost me (and my company) some days to fix... Approved: 9/16/2010 8:50 PM
Microsoft had removed "Windows Installer CleanUp" Approved: 8/9/2010 1:41 AM
Created on 5/6/2009 12:44 PM.
Last Modified on 5/6/2009 3:05 PM.
Last Modified by No Author Name Available!.
Skill Level: Advanced.
Article has been viewed 19082 times.
Rated 6 out of 10 based on 43 votes.
Print Article
Email Article