The Wiert Corner – irregular stream of stuff

Jeroen W. Pluimers on .NET, C#, Delphi, databases, and personal interests

  • My badges

  • Twitter Updates

  • My Flickr Stream

  • Pages

  • All categories

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 1,779 other followers

SQL Server 2005 setup fails when MSXML Core Services 6.0 Service Pack 2 has already been installed

Posted by jpluimers on 2010/06/25

Recently, I had to configure a pretty up-to-date Windows XP SP3 VM with SQL Server 2005 for a proof of concept.

The SQL Server 2005 setup failed consistently on installing MSXML 6.
I tried making the XP VM really up-to-date.
But the SQL Server 2005 setup still failed at the same reason.

In the end it appeared that the MSXML 6 install that is included in the SQL Server 2005 install barfs when MSXML 6 SP2 is already installed.Microsoft even has an article about that on-line (duh!).

Contrary to the Microsoft article, the MSXML 6 installation log can be found here:

%ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\Log\Files\

You will find something like this in the the MSXML 6 installation log:

...
Property(S): Upgrade_Confirmation = A lower version of this product has been detected on your system. Would you like to upgrade your existing installation?
Property(S): AdminMessage = Setup requires user to be in the administrator group in order to continue the installation process. Setup is aborting as the current user is not in the administrator group.
Property(S): SupportedOSMessage = Installation of this product failed because it is not supported on this operating system. For information on supported configurations, see the product documentation.
...
MSI (s) (14:4C) [13:34:03:952]: Product: MSXML 6 Service Pack 2 (KB954459) -- Configuration failed.
...

Edit – 20100723: the “Windows Installer CleanUp Utility” disappeared from the Microsoft web-site (see comments), so resolving this problem is not possible in an official way any more.
What you should do instead is never install the RTM SQL Server 2005, just install the SQL Server 2005 SP3, as it is a full install anyway.

Here is what you need to to to get the MSXML 6 problem resolved:

  1. Download the Windows Installer CleanUp utility. To do this, visit the following Microsoft Web site: KB290301
    (direct download)
  2. Run the Windows Installer CleanUp utility.
  3. Select MSXML6 Service Pack 2 (KB954459) [6.20.1099.0] in the list, and then click Remove.
  4. Install SQL Server 2005
    (The MSXML 6 will reinstall itself as part of the process)
  5. Install your SQL Server 2005 service pack
    (currently the latest one is Service Pack 3 –
    download SQL Server 2005 Express SP3
    download SQL Server 2005 SP3)
  6. Verify the version numbers of the installation at the page How to identify your SQL Server version and edition

Back to real work :-)

–jeroen

Via: SQL Server 2005 setup fails when MSXML Core Services 6.0 Service Pack 2 has already been installed.

5 Responses to “SQL Server 2005 setup fails when MSXML Core Services 6.0 Service Pack 2 has already been installed”

  1. Ajeesh said

    Thank you! This helped.

  2. Bal said

    You saved my time.. Thanks Bud

  3. José Mª Fueyo said

    The Installer CleanUp utility had been removed from both, KB article and your direct link. Threfore there is no solution today

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

 
%d bloggers like this: