Free Information Technology Magazines and eBooks

Sunday, April 12, 2009

SQL Server Error 2147749896

This morning while I was trying to install SQL SERVER 2005 express on my laptop with Microsoft Vista SP1, I encountered the following error:

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



After several minutes of searching for answers online, I found a batch file that worked on my machine. The batch file contains the following scripts:


@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


Save the script above as .bat file then run it on the command line. Then after several minutes and you can see the :End statement, try to reinstall the SQL server again and it should already be fixed.

After further reading on some forums, some users claims that the script does not work for them and tried the following steps instead.


- Kill the service winmgmt
- Copy the whole %windir%\system32\wbem folder from another machine where the installation of SQL server is good. (it suppose to fix the config files).


If you have other solutions that works, please share it to us. Good day to all!

4 comments:

Anonymous said...

Thank you this worked and saved my day! Great little article!

Anonymous said...

Thank you, this magic works for me.

Anonymous said...

Thanks for the information.
Ali.

Anonymous said...

It worked for me! Thanks!