SQL Server setup fail when MSXML SP 2 has already been installed
SQL Server 2005 setup fails when MSXML Core Services 6.0 Service Pack 2 has already been installed.
"I am trying to install the new version of the UT, version 2.5.115 on my computer, which has the Windows XP Professional version 2002 operating system but am having problems with the installation. I get the following error messages after the installer attempts to run the SQL setup"
SQL Server error pic
And this is the error message received when the UT is launched.
Run-time error ...
SQL Server WMI provider is not available on...
__________________________________-
ANSWER
The UT uses Microsoft Sql Server Express 2005 (a free download from Microsoft). The UT installs Microsoft Sql Server Express 2005 if it doesn’t exist.
Inside the SqlSetup0002.cab file (which is like a zip file) there is a summary file which contains the following:
--------------------------------------------------------------------------------
Machine : GEM-DELL6000
Product : MSXML 6 Service Pack 2 (KB954459)
Product Version : 6.20.1099.0
Install : Failed
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_GEM-DELL6000_MSXML6_1.log
Error Number : 1603
--------------------------------------------------------------------------------
Sometimes the install fails and is detailed in the following Microsoft Knowledgebase Article entitled “SQL Server 2005 setup fails when MSXML Core Services 6.0 Service Pack 2 has already been installed” http://support.microsoft.com/kb/968749
Included in the article is a suggested fix. The fix details using the “Windows Installer Clean Up” tool to remove “MSXML 6 Service Pack 2”. Then rerun the UT installer and the UT software and Sql Server should install properly. The UT will then launch successfully.
