What a nightmare! Having XP Service Pack 3 installed leaves you with an inline upgrade to the MSXML 6.0 Parser. This version is newer than the version used by the base install of SQL 2005. Big Fail!
Microsoft officially doesn't have a working solution, but a work around. See http://support.microsoft.com/kb/968749 for further details on their work around.
While their work around is feasible for single install cases, software distributors are left dealing with the problem of how to get a product installed on a customer base without a support nightmare.
Many Google searches have turned up a rather simple solution. The idea is based on what the GUI from KB968749 is actually doing behind the scene. The Microsoft Office Install Clean Up Utility is a fancy wrapper for the MSIZap.exe tool. And all good tools have a command line interface to use. Some digging around in the registry you can find the ID for the MSXML 6.0 Parser to be {1A528690-6A2D-4BC5-B143-8C4AE8D19D96}.
The simplest solution is to call MsiZap T {1A528690-6A2D-4BC5-B143-8C4AE8D19D96} to remove the reference to the version installed and allow SQL 2005 to install.
Posted
Sep 11 2009, 12:54 PM
by
Jerald Carter