A very quick posting to maybe save someone some time while trying to get this component installed and for vCenter Configuration Manager’s system checks to verify it.
One of the components required for the installation of the collector and web server for VCM is SQLXML SP1. The installation documentation from VMware states the below in relation to the requirement:
Verify the SQLXML Version
Verify that SQLXML 4.0 SP1 is installed. Version 4.0 SP1 is installed with SQL Server 2008 R2.
- Click Start and click Control Panel.
- Click Programs and select Programs and Features.
- Verify that SQLXML 4.0 SP1 appears in the list of installed programs.
- Verify that the version is 10.0.1600.60 or later.
- If the version is not SQLXML 4.0 SP1 10.0.1600.60 or later, or only an earlier version of SQLXML is installed, install SQLXML 4.0 SP1.
Firstly, I did not have it installed so searched for SQLXML SP1, downloaded, and installed it. I then checked the version and I had downloaded a newer version than the 10.0.1600.60 version mentioned in the installation documentation but as shown above they said that would be fine. As you can see below my version of SQLXML SP1 was 10.1.2532.0
My problems came about when i ran the installation and the checker would run through but fail giving me an error for SQLXML SP1 even though I had it installed. It seems despite the documentation saying versions newer than 10.0.1600.60 work it seems the checker doesn’t like it and won’t allow you to carry on. Therefore, I had to download the 10.0.1600.60 version and then the checker passed
The path to the “correct” version is http://www.microsoft.com/en-us/download/details.aspx?id=8824. Obviously, you have to download the instructions and then do the installation from there. SQLXML is near the bottom of the page.