Knowledge Base : Glossary : Suggest a Question
Search The Knowledge Base
Browse The Knowledge Base
Knowledge Base : General : SQLServer

WMI Configuration Error in SQLServer installation(SQL2005 Express)

While installing SQL2005 EXPRESS on XPSP3 , wmi provider error occurred

From the SQL Core log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files

Setup Consistency Check Report for Machine: SERVER
*******************************************
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 SERVER Error:2147942402 (0x80070002).
The checkResult returned is 2147942402
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.





Solution

1.Stop the Windows Management Instrumentation service(net stop winmgmt)
2.copy and paste the required file c:\windows\system32\wbem\wmiprvse.exe from existing windows xp sp3 machine to Destination machine
3.Start the Windows Management Instrumentation service(net start winmgmt)
4.uninstall the existing Native client & sql support files
5.Install the SQL server



Note: Replace the file(wmiprvse.exe)with same version of Operating system and Service Pack










Related Articles
There are no related articles


Viewer Comments Add Comment
No viewers have posted comments

Powered By AutoKB