SQL SERVER – FIX : ERROR : The SQL Server System Configuration Checker cannot be executed due to WMI configuration

SQL SERVER – FIX : ERROR : The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine Error:2147749896 (0×80041008)

 referred Link:http://blog.sqlauthority.com/2009/04/12/sql-server-fix-error-the-sql-server-system-configuration-checker-cannot-be-executed-due-to-wmi-configuration-on-the-machine-error2147749896-0%C3%9780041008/ 

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 t

18 Responses

  1. 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.

  2. Libyan,

    would you post your error? I will take a look at that.

  3. 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

  4. 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 (0×80004002).

    For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc

    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:
    http://boyersnet.com/blogs/chucks_blog/archive/2007/12/13/fix-for-sql-server-system-configuration-checker-cannot-be-executed-due-to-wmi-confiuration.aspx

    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 “root\cimv2″, 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.

  5. In addition to the previous blog, I am currently using Windows Vista Home Premium Edition.

  7. 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

  8. Thanks again…..

  9. TITLE: SQL Server Setup failure.
    ——————————

    SQL Server Setup has encountered the following error:

    Configuration system failed to initialize

    Error code 0x84B10001.

    ——————————
    BUTTONS:

    OK
    ——————————

  10. Thanks a lot .Cheers !!

  11. on April 27, 2010 at 4:50 am | ReplyStuart Pearson

    just downloaded your batch file and my virus scanner reported it as a virus

  12. Hi pinal ,

    there is a virus .

  13. 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).

  14. Works as expected and got past the WMI error during the rule check in the SQL Server 2008 Installer. Thanks Pinal!

  15. 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 (0×80004002).

    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.

  16. 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 (0×80041013)

    Thanks
    Sushil

  17. 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?

posted on 2011-04-11 13:43  潇潇雨  阅读(982)  评论(0)    收藏  举报

导航