I came across an interesting error today trying to install SQL Server 2005 client tools on Vista Business. The error specifically was:
The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine SCOTT Error:2147500034 (0x80004002).
The checkResult returned is 2147500034
Below is an excerpt from the bootstrap installer log.
Machine = SCOTT, Article = WMIServiceWin32OSWorking, Result = 2147500034 (0x80004002)
Machine = SCOTT, Article = WMIServiceWin32CompSystemWorking, Result = 2147500034 (0x80004002)
Machine = SCOTT, Article = WMIServiceWin32ProcessorWorking, Result = 2147500034 (0x80004002)
Machine = SCOTT, Article = WMIServiceReadRegWorking, Result = 0 (0x0)
Machine = SCOTT, Article = WMIServiceWin32DirectoryWorking, Result = 70347 (0x112cb)
Machine = SCOTT, Article = WMIServiceCIMDataWorking, Result = 70347 (0x112cb)
Machine = SCOTT, Article = XMLDomDocument, Result = 0 (0x0)
*******************************************
Setup Consistency Check Report for Machine: SCOTT
*******************************************
Article: WMI Service Requirement, Result: Error
Description: Windows Management Instrumentation (WMI) is not functioning properly. Further checks cannot be performed. Action: Please make sure Windows Management Instrumentation (WMI) is functioning properly.
The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine SCOTT Error:2147500034 (0x80004002).
The checkResult returned is 2147500034
The checkResult for local machine returned by CheckSCCResult is 70036
Setup is unable to proceed because one of scc articles failed. Please address those errors before continuing the setup.
Not until I googled the first line of the above did I find the final solution posted
here in Jin Feng's post.
1. start->run->cmd.exe
2. net stop winmgmt
3. net start winmgmt
4. start->run->wbemtest.exe
5. click "connect", type in "root\cimv2", click "connect" button
6.click "Enum Instances...", type in "win32_processor", click OK
If all steps above succeeds, please try to run setup again.
If not, please share which step fails and with what error. These steps involve no SQL setup, so we can isolate if this WMI issue you're seeing is related to SQL setup or OS only.
Once I attempted those tests I recieved the following error as described by EricJudge06
Number: 0x80004002
Facility: <Null>
Description: No such interface supported
Eric also posted the final solution as shown here:
1. Add network service account to administrators group.
2. Add authenticated users to following registry keys:
HKCR\CLSID\{73E709EA-5D93-4B2E-BBB0-99B7938DA9E4}
HKCR\CLSID\{7C857801-7381-11CF-884D-00AA004B2E24}
HKLM\Software\Microsoft\WBEM\CIMOM
I set the permissions to read only on the registry keys instead of full control as he describes. Once that was done we ran the SQL 2005 installer again and everything worked like a charm.