Home Linux Servers Resolving SQL Server Express 2005 setup error with MSXML 6.0

Resolving SQL Server Express 2005 setup error with MSXML 6.0
Written by Kwok Yao Chim   
Tuesday, 26 February 2008 14:18
SQL Express 2005 MSXML 6.0 Parser error!!
I've noticed that a lot of Windows XP (SP2) users including myself have tried to install SQL Express 2005 only to find that the installation fails halfway through giving an error that it couldn't install MSXML 6.0 Parser.

And there's more to this problem than meets the eye...
A lot of websites and their community forums say that you should remove and re-install MSXML 6.0, but when you attempt to remove it and try to re-install, the standard Install/Remove Software does not completely remove MSXML 6.0 and its registry.

This eventually will give you an error similar to "A later version of MSXML 6.0 Parser is already installed." and so you're back to square one.

Fortunately there is a way to resolve this problem and MS does contribute to the help in a form of supplying a program which will cleanly uninstall unwanted programs.

Step 1
Go and download the Microsoft Installer CleanUp Utility and install it.

Step 2
Once installed, run the program and choose to uninstall MSXML 6.0 Parser. This should cause a full clean uninstall. (fingers crossed)!

Step 3
Go and download the MSXML 6.0 package from the SQL Server Express website and install it.

Step 4
After successfully installing the original MSXML 6.0 Parser, you can now install the SQL Server Express 2005

These steps are simple simple but if you do run into any problems of removing MSXML 6.0, you may want to try a commercial program called Your Uninstaller (google it).

By the way, when installing your SQL Server Express, keep a note of your server name instance, you may need it if you use Visual Web Developer Express with SQL.