Home Dashboard Directory Help
Search

SQL Express 2005 install will fail if computer has MSXML6 SP2 installed by jfrenia


Status: 

Active


18
0
Sign in
to vote
Type: Bug
ID: 390101
Opened: 12/30/2008 8:53:19 AM
Access Restriction: Public
4
Workaround(s)
view
19
User(s) can reproduce this bug

Description

If you have a version of SQL Server installed on a machine and then Windows updates are run, it will update msxml6 sp2, which will make the msxml files protected through windows. If you then try to install SQL Express 2005 or 2008, these installs will fail and can't be installed.
Details
Sign in to post a comment.
Posted by Desiredfx on 12/23/2010 at 9:10 AM
I was able to fix this issue by doing the following.

http://support.microsoft.com/kb/968749

To workaround the problem:
Download MSMXL fix from the following Microsoft website:

http://download.microsoft.com/download/E/3/F/E3F51FFB-505D-480E-9F67-0DD3A9680DEE/MSXMLFix.EXE

Extract the fix, and then copy the MSXML6.MSP file and the MSXML_FIX.VBS file to the same folder.
Run cscript MSXML_FIX.VBS.

Below is the output after i ran the command.
==============================================================
C:\IT WORK>CSCRIPT MSXML_FIX.VBS
Microsoft (R) Windows Script Host Version 5.7
Copyright (C) Microsoft Corporation. All rights reserved.

=> OS version = 5.1.2600
=> Product code: {56EA8BC0-3751-4B93-BC9D-6651CC36E5AA}
=> Product name: MSXML 6 Service Pack 2 (KB973686)
=> Command: MSIEXEC /X {56EA8BC0-3751-4B93-BC9D-6651CC36E5AA} PATCH="C:\IT WORK\
msxml6.msp" /qn /l*v C:\DOCUME~1\DONNA~1.CUR\LOCALS~1\Temp\msxmlpatch.log
=> PID: 3572
=> MSXML 6 Service Pack has been uninstalled
===========================================================================





Posted by Mimosa Arts on 8/31/2010 at 11:40 AM
OK, now that the Cleaner has been taken away how does one correct the situation where SQL Server 2005 Express cannot be installed due to the fact that MSXML 6 SP2 is on my XP SP3 box?!?!?!?!?!?
Posted by Rarediamond25 on 7/15/2010 at 2:46 PM
Like Ben said, I was a bit premature as well. workaround from Judge55 just worked fine. Thank you for the workaround.
Posted by Rarediamond25 on 7/15/2010 at 1:02 PM
Hello, I am getting error while installing SQL Server 2005 in XP SP3. I found the work around using Windows Installer Cleanup utility however the utility has been removed. How to fix it? Please help.

This is the error I am getting:
"MSI (s) (C4:38) [14:25:04:837]: Windows Installer reconfigured the product. Product Name: MSXML 6 Service Pack 2 (KB954459). Product Version: 6.20.1099.0. Product Language: 1033. Reconfiguration success or error status: 1603."
Posted by Ben Fairchild on 6/30/2010 at 5:21 AM
I was a bit premature. The last workaround from Judge55 did solve the issue for me. Many thanks!
Posted by Ben Fairchild on 6/29/2010 at 1:20 PM
Since Windows Installer Cleanup utility has been removed due to causing problems, the solution and workarounds are no longer valid.
Posted by Microsoft on 6/21/2010 at 4:23 PM
Than you again for reporting this issue to us. We are working on addressing this issue for Yukon SP4.

Thank you,
Mohamed El Hassouni [SQL Server]
Posted by Neo the 1 on 5/7/2010 at 12:34 AM
Same error here, as I am installing a XP Pro VPC for maintaining an old system that requires SQL SERVER 2005.

IT'S ridiculous to have this kind of fundamental error in such a big product. Why it only checks for older version?
Posted by Microsoft on 4/1/2009 at 1:28 PM
The latest comments from the customer are not related to original issue with MSXML6. Please file a new bug for this issue of uninstall SQL Server 2005 Express. For the original issue we have published a KB. (http://support.microsoft.com/kb/968749)

Thanks,
Byungho

Posted by Microsoft on 4/1/2009 at 1:28 PM
The latest comments from the customer are not related to original issue with MSXML6. Please file a new bug for this issue of uninstall SQL Server 2005 Express. For the original issue we have published a KB. (http://support.microsoft.com/kb/968749)

Thanks,
Byungho

Posted by gdhar on 3/29/2009 at 12:07 AM
Hi,

I am facing weired issue of SQL Express 2005 over Windows XP SP2. I get XP OS crashed when I do following steps.

1 Install SQL Server Standard 2005 on XP SP2 with all the components.
2 Simply Uninstall SQL Server Standard 2005. This will leave some SQL Server related files and registry entries even after successful uninstallation.
3 Now, install SQL Server Express 2005 on the same machine. During installation of Database Services component, the installation fails and OS reboots with crash. I can get logged in to XP but it just goes on reboots with following exception.

"Your SQL Server installation is either corrupt or has been tampered with (Error generating instance ID from name). Please uninstall the re-run setup to correct this problem."

I cannot even go to Control Panel to remove any programs. I tried using Registry cleaner, Win Installer Cleanup Utility after Step 2, but nothing worked for me. Please suggest the solution.


Thanks,
Gdhar

Posted by Dialtones on 3/24/2009 at 7:42 AM
Oh good, but not really. I thought I had done something wrong, I do not get any error messages, in fact I get mesage update installed successfully, but the available update never goes away, always there for me to install. If anyone else has had this problem, please let me know if you were able to fix it and how. thank you
Dialtones
Posted by Microsoft on 3/13/2009 at 11:15 AM
Thanks for helping us improve SQL Server experieinces.

From the log file, I see that you encountered this issue with SQL Server 2005 Express installation on a XP SP3 machine. But you mentioned that it can happen with SQL Server 2008. There is one known issue. SQL Server 2005 Express installation fails when you run it over a XP SP3 machine which was upgraded from XP SP2 machine with MSXML6 SP2 already installed. However, we did not experience this on other OS nor with SQL Server 2008.

Can you verify if you have seen this issue with SQL Server 2008 or on other OS?

Thanks
Posted by JohnReam on 2/19/2009 at 1:43 PM
Here's what is needed ASAP: Immediately update/fix/re-release the SQL 2005 Express Edition SP3 Setup.exe, to better DEAL with the possibility of MSXML 6.0 SP2's on the client machine. Don't HALT the rest of the SQL Installation.

Is anyone from Microsoft aware of this problem? I would venture to guess that this problem is not limited to SQL 2005 Setups, but most other product installers as well, that roll MSXML.
Posted by Tuono_Tom on 2/11/2009 at 8:23 AM
Where's the fix? An update that blocks installs of MS products requires a solution NOT a 'work-around'. Jimminy....

-T_T
Posted by Microsoft on 1/13/2009 at 4:10 PM
Thanks for contacting us. We will investigate this issue and let you know what we determine.

Thanks,
Peter
Posted by tftftf on 12/30/2008 at 9:22 AM
I get a similar error when I try to add a local SQL server instance using SQL Server 2005 Standard Edition on XP SP3. SQL server client apps were previously loaded on the XP box and worked correctly, but when I tried to install a local SQL server instance, the install failed with an MSXML configuration error. See excerpts below:

----- BEGIN Summary.txt excerpt -----
Machine         : IDC1TRS8808
Product         : MSXML 6 Service Pack 2 (KB954459)
Product Version : 6.20.1099.0
Install         : Failed
Log File        : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0012_IDC1TRS8808_MSXML6_1.log
Error Number    : 1603
----- END Summary.txt excerpt -----

----- BEGIN MSMXL log file excerpt -----
MSI (s) (90:CC) [14:16:02:302]: Note: 1: 1729
MSI (s) (90:CC) [14:16:02:302]: Product: MSXML 6 Service Pack 2 (KB954459) -- Configuration failed.
MSI (s) (90:CC) [14:16:02:302]: Windows Installer reconfigured the product. Product Name: MSXML 6 Service Pack 2 (KB954459). Product Version: 6.20.1099.0. Product Language: 1033.
Reconfiguration success or error status: 1603.
----- END MSMXL log file excerpt -----
Sign in to post a workaround.
Posted by Desiredfx on 12/23/2010 at 9:11 AM
I was able to fix this issue by doing the following.

http://support.microsoft.com/kb/968749

To workaround the problem:
Download MSMXL fix from the following Microsoft website:

http://download.microsoft.com/download/E/3/F/E3F51FFB-505D-480E-9F67-0DD3A9680DEE/MSXMLFix.EXE

Extract the fix, and then copy the MSXML6.MSP file and the MSXML_FIX.VBS file to the same folder.
Run cscript MSXML_FIX.VBS.

Below is the output after i ran the command.
==============================================================
C:\IT WORK>CSCRIPT MSXML_FIX.VBS
Microsoft (R) Windows Script Host Version 5.7
Copyright (C) Microsoft Corporation. All rights reserved.

=> OS version = 5.1.2600
=> Product code: {56EA8BC0-3751-4B93-BC9D-6651CC36E5AA}
=> Product name: MSXML 6 Service Pack 2 (KB973686)
=> Command: MSIEXEC /X {56EA8BC0-3751-4B93-BC9D-6651CC36E5AA} PATCH="C:\IT WORK\
msxml6.msp" /qn /l*v C:\DOCUME~1\DONNA~1.CUR\LOCALS~1\Temp\msxmlpatch.log
=> PID: 3572
=> MSXML 6 Service Pack has been uninstalled
===========================================================================
Posted by Welsh-Wizard on 5/29/2009 at 2:21 AM
The only solution to this is to remove update KB954459 from your machine. You cannot do this however via add/remove programs as it fails. You need to use the Windows Installer Cleanup Utility. You can either do this via its interface but if you have SQL 2005 Express as part of a product setup, as i have using the interface is not an option. The cleanup utility is really just a UI to a command line tool called msizap! I have included this within my setup and driven it with the following command lines to remove update 954459.

msizap A! {1A528690-6A2D-4BC5-B143-8C4AE8D19D96}
msizap T! {1A528690-6A2D-4BC5-B143-8C4AE8D19D96}

The first line sets all the ACLS for admin access and the second line actually does the removal. After running these you can then successfully install SQL 2005!
Posted by VorDesigns on 5/27/2009 at 10:13 AM
Unable to uninstall KB954459
Cleanup Utility successfully removed installer (it disappeared from the list)
WSUS Installation of SQL2005 Express SP3 sucessful
Product: MSXML 6 Service Pack 2 (KB954459) -- Installation failed.
Posted by CheesyPeteza on 1/5/2009 at 4:43 AM
* Uninstall KB954459 from Add/Remove Programs
* Install Windows Installer Cleanup Utility from http://support.microsoft.com/kb/290301
* Run the Windows Installer Cleanup Utility and remove MSXML 6 SP2
* SQL Server 2005 Express will now install
* Reinstall KB954459
File Name Submitted By Submitted On File Size  
error3.jpg (restricted) 12/30/2008 -
SQLSetup0009_MSXML6_1.log (restricted) 12/30/2008 -
error1.jpg (restricted) 12/30/2008 -
error2.jpg (restricted) 12/30/2008 -