More info / good news : installing SQL Server on XP SP3 with MSXML6 SP2

I have some good news about a problem I described a while ago, concerning attempts to install SQL Server on XP SP3 machines.  The install would fail because XP SP3 places MSXML files under system protection, and so attempts by installation programs to update them would fail.

I posted some ugly workarounds, and at least one slightly better workarounds emerged from users who visited the blog post.  While the kludges worked, they were a bit messy, requiring you to manually uninstall the MSXML components, and even then it wasn't always enough.  A much easier workaround involving editing the registry has existed all along, but it was solely in the hands of the engineers over at Microsoft Product Support Services (PSS), who decided that modifying the registry was far too dangerous and sophisticated for mere SQL Server users running XP, and so they prevented the registry fix from being publicized (either in a Knowledge Base article or, while waiting for said article, on an unofficial site like this one).  Instead, they decided that their "solution" would be to require users (or at least, users who figured out that there was an easier fix they could obtain) to call support, lay down the close to $300 to open a support case, get the fix, then push for a refund.  (Unless you were a Microsoft Partner, in which case, you could allegedly get the fix from the unfinished internal Knowledge Base article via the Partner KB.)

(All the while, there are over 1,400 KB articles, in English alone, that mention "regedit.exe" according to this Google search.)

Anyway, enough complaining; on with the good news.  After much pressure, apparently mostly from yours truly, the support folks over at PSS have reluctantly agreed to make the registry change public, in a forthcoming KB article.  I do not have an exact delivery date for you, but I was told that it should be available by the end of the month. If you see it before I do, please post here or send me e-mail (<firstname>.<lastname> @ gmail.com).

Hopefully it does not turn out to be a cruel April Fool's joke.

Aaron Bertrand

I am a passionate technologist with industry experience dating back to Classic ASP and SQL Server 6.5. I am a long-time Microsoft MVP, speak frequently at conferences, and write at SQLPerformance and MSSQLTips. I recently joined the team at Wayfair and hope to blog about some of the scale challenges I've already started helping to solve.

4 Responses

  1. Will Patrick says:

    So, where's the article?

  2. AaronBertrand says:

    Will, please see my follow-up post.  Apparently, their promise WAS an early April Fool's joke.
    /blogs/aaron_bertrand/archive/2009/03/20/one-more-post-about-msxml6-sp2-xp-sp3-and-sql-server-i-ve-been-duped.aspx

  3. AaronBertrand says:

    Some unsupported workarounds that might be a better approach than the cleanup utility:
    http://is.gd/q6Lv
    http://is.gd/q6MT

  4. Arthur says:

    guys help me, i cant uninstall the msxml 6.0 from my PC to be able to install the SQL Server 2005…still cant understand, coz my windows installer utility cant uninstall the file…..