A couple of days back I had my computer formatted. I reinstalled it with Vista SP1 32bit. Subsequent to installing other indispensable software I tried to install SQL Server 2005 . However, it instantly displayed the following error message.
The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine Error:2147749896 (0×80041008).
It was a bit frustrating for me as it was pretty late and I ardently wanted to install SQL Server 2008 right after I was done with installing SQL Server 2005. I pinged my friend James Locazicoski with the above error message. James came to my rescue with a batch file. I immediately ran the batch file on my server; it took a while and when it was done it closed itself on vista. I kept my fingers crossed and ran my SQL Server installer right after that. There was no WMI error to wreck my nerve. I was able to successfully install SQL Server right after that.
Well, this bat file is certainly a life savior. While searching online I found this script at several places, which reflects its popularity and usability. I need help from my readers regarding the following information.
1) Where is the original source of this script?
2) What is this script actually doing?
Once I receive response to both the above questions, I will post the answers on my blog with due credit to my readers.
Download Batch File Here
Reference : Pinal Dave (https://blog.sqlauthority.com)
44 Comments. Leave new
Thanks for this post.I Suffered from this problem with windows vista Home premium,but i can’t install sqlserver 2005.
And I tried to download batch file,but there is error in the page.
I got the same WMI error for the SqlExpress installation.
Mine was Windows Xp Sp2.
There TrendMicro Office Scan Anti virus is installed .But i want to install sqlexpress with out stopping Firewall.
Can i know detail of this error and why it is happening.
I am also havi
Dear Pinal,
I do not have any knowledge on computers except the very basic of using it. I hope you will be patient with me.
I am taking an online course which requires that I install SQL Server 2005 Express Edition. I received the installation CD package which also required that I install Microsoft .NET Framework 2.0.
When I was trying to install the SQL Server 2005 Express Edition, this was the error message I received:
TITLE: Microsoft SQL Server 2005 Setup
——————————
The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine (my name)PC Error:2147500034 (0x80004002).
For help, click:
I tried to contact the school’s tech support, however have not been able to get any help from them. I went to google and searched for the above Error message.
Here is a site which I got:
My question is, would it be safe for me to answer YES for steps 2 & 3?
1. start->run->cmd.exe
2. net stop winmgmt (Y,N)
3. net start winmgmt (Y,N)
4. start->run->wbemtest.exe
5. click “connect”, type in “rootcimv2”, click “connect” button
6.click “Enum Instances…”, type in “win32_processor”, click OK
Are there any other blogs I can use? Will you be able to assist me?
Thank you.
In addition to the previous blog, I am currently using Windows Vista Home Premium Edition.
Exelent!!
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
Thanks again…..
TITLE: SQL Server Setup failure.
——————————
SQL Server Setup has encountered the following error:
Configuration system failed to initialize
Error code 0x84B10001.
——————————
BUTTONS:
OK
——————————
Thanks a lot .Cheers !!
just downloaded your batch file and my virus scanner reported it as a virus
Hi pinal ,
there is a virus .
the script FIXWMI.CMD resolved my issue of
The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine Error:2147749896 (0×80041008).
Works as expected and got past the WMI error during the rule check in the SQL Server 2008 Installer. Thanks Pinal!
I just ran the batch file trying to see whether it would help me install SP4 for SQL Server 2005. It didn’t work, probably because my problem is different. Here is the error message:
TITLE: Microsoft SQL Server 2005 Setup
——————————
The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine [machine name] Error:2147500034 (0x80004002).
I was trying to install directly by running the update exe file as administrator on a Vista 32 system. I wasn’t doing it through Windows Update.
What else can be tried? Thanks.
I have tried all the ways listed, running batch file, reinstalling wmi but i still keep getting the same error.
The error number looks different thought.
The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine
Will appreciate any help. error 2147749907 (0x80041013)
Thanks
Sushil
i got same problem some day ago,i used fixwmi.cmd file and it fixed d problem,but nw i got same prob n ran same file.but it is not working?wats d prob?what shud i do?
sir i have serarched a lot to fix Configuration Checker cannot run problem but i failed then i downloaded yoyr batch file and run the script and it is resolved it’s great thanks.
Error: while installing Microsoft SQL Server 2005 on WINDOWS XP Service Pack3
SQL SERVER – FIX : ERROR : The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine Error:2147749896 (0×80041008)
I had used the script
FIXWMI.CMD
————————
@echo on
cd /d c:temp
if not exist %windir%system32wbem goto TryInstall
cd /d %windir%system32wbem
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
but it is unable to fix the problem..
Please tell me if there is any alternative way to resolve the Error.
Thank you so much!
My problem is solved!
I also got a virus infection detected from my mcafee scanner!