Error Message: Setup failed. Refer to the Setup log for details.
Symptoms: When installing Data Workbench, an error occurs during the Microsoft SQL Server 2005 Setup. The screen indicates that MSXML6 setup failed which is a prerequisite for Microsoft SQL Server 2005.
The screen shot of this error is as follows:
Cause: This is a Microsoft issue relating to MSXML 6.0 and XP SP3. 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.
Resolution: The most likely work around for this issue is to use the Windows Installer CleanUp utility to remove references to MSXML 6.0 Service Pack 2. To do this, follow these steps:
- Download the Windows Installer CleanUp utility. To do this, visit the following Microsoft Web site:
- Run the Windows Installer CleanUp utility.
- Select MSXML6 Service Pack 2 (KB954459) [6.20.1099.0] in the list, and then click Remove.
- Install SQL Server 2005.
Note The Windows Installer CleanUp utility will not roll back the MSXML binaries to a previous version.
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.
Please see the Microsoft Knowledge Base article below for more information.