Error:

The SQL Server system configuration checker cannot be executed due to WMI configuration on the machine. Error 2147749896

Error Message:

Causes:

1. Microsoft Data Access Components may not be installed
2. Unfinished SQL Server 2005 components may be present
3. Components or files related to WMI service might be unregistered or missing.
4. The problem was that the WMI repository is corrupted. Reinstall the WMI.

Workaround 1: [Windows 2000 or Windows XP]

1. Check the version of MDAC you have installed.  SQL Server will require MDAC 2.8 or higher.  To check MDAC:
   • Click Start / Run.
   • Type regedit
   • Click OK
   • Navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\DataAccess
   • Note the Registry Key for Version. If less than 2.8.xxxx,
   • download and install the latest MDAC 2.8 version.

Workaround2

Download the attached file and execute the batch file.

Re-install SQL server express 2005 again.

Download: SqlWmiFix.bat

Workaround 3:

Uninstall any remainant SQL Server 2005 components, if present. Most notably:

• Microsoft SQL Server Native Client
• Microsoft SQL Server Setup Support Files (English)
• Microsoft SQL Server VSS Writer