SYMPTOMS
SQL 2005 portion of the ILMS installation process fails with 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 following is a screen shot of the SQL installation dialog when this error occurs. Note the failed components - \"MSXML6\" and \"SQL Server Database Services\":
CAUSE
When SQL Server Setup tries to install MSXML 6.0 SP2, it detects that this version of MSXML 6.0 is already installed on the computer (described in MS Knowledge Base article 954459). 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.
The full MS KB article can be found here: http://support.microsoft.com/kb/968749
RESOLUTION
1. Download and install the \"Microsoft Windows Installer Cleanup Utility\" found here: http://www.iluminartechnologies.com/fil ... sicuu2.zip
2. Start \"Windows Install Clean Up\" which should now be available in \"All Programs\".
3. Select the programs that you want in the Installed Products list in the Windows Installer Cleanup dialog box. In this case, select only \"MSXML 6 Service Pack 2\" as shown in the following screen shot:
After you make this selection and click \"Remove\", the utility removes only the Windows Installer configuration information that is related to this program.
4. Install ILMS.
NOTES
If it is necessary to reinstall MSXML6.0, it can be found here:
http://www.microsoft.com/downloads/deta ... layLang=en
APPLIES TO
Windows XP Operating System with Service Pack 3 and all variants of SQL 2005.