Receiving WMI configuration error. SQL Server System Configuration cannot be executed due to that PDF Print E-mail
Written by krishanu sarkar
Monday, 14 December 2009 13:04

The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine mymachine Error:2147749896 (0x80041008).

I uninstall all version of Visual Studio 2005 just kept Microsoft .NET Framework 2.0. Still I am getting this error when I am running SQLEXPR.exe to install the SQL Server 2005 Express.

Solution:

I found this batch file and ran it and it fixed my WMI problems on SQL Server 2003. Copy this into notepad as save as fixwmi.cmd and then from a command line run c:\fixwmi.cmd.

It takes several minutes to complete and at points it appears that it is not running but it is. After it is complete, you see the :END statement start the SQL server installation again and you should be fixed.

FIXWMI.CMD
------------------------

@echo on
cd /d c:\temp
if not exist %windir%\system32\wbem goto TryInstall
cd /d %windir%\system32\wbem
net stop winmgmt
winmgmt /kill
if exist Rep_bak rd Rep_bak /s /q
rename Repository Rep_bak
for %%i in (*.dll) do RegSvr32 -s %%i
for %%i in (*.exe) do call :FixSrv %%i
for %%i in (*.mof,*.mfl) do Mofcomp %%i
net start winmgmt
goto End

:FixSrv
if /I (%1) == (wbemcntl.exe) goto SkipSrv
if /I (%1) == (wbemtest.exe) goto SkipSrv
if /I (%1) == (mofcomp.exe) goto SkipSrv
%1 /RegServer

:SkipSrv
goto End

:TryInstall
if not exist wmicore.exe goto End
wmicore /s
net start winmgmt
:End

Last Updated on Tuesday, 05 January 2010 12:12