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

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 (http://blog.SQLAuthority.com)

About these ads

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

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

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

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

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

    SQL Server Setup has encountered the following error:

    Configuration system failed to initialize

    Error code 0x84B10001.

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

    OK
    ——————————

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

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

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

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

  10. 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%\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

    but it is unable to fix the problem..
    Please tell me if there is any alternative way to resolve the Error.

  11. Hi Pinal

    I was suffering with this while I am trying to install sql server 2008 r2 in windows 7. there error was like this

    sql server has encountered the following error:

    could not load file or assembly, 0 bytes loaded from system, version=2.0.0.0, culture=neutral, publickeytoken=b77a5c561934e089 or one of its dependencies. an attempt was made to load a program with incorrect format.

    error code:0x84B10001.

  12. thanks dude , i was really suffer from this problem but b’coz of u’r a download batch file ..& it woks for XP

  13. I got the error–Could not find a package to install on the installation media while installing sql server 2005 on windows xp.

  14. I am also having a problem in installing SQL Server 2008 R2, WMI fails, I executed the batch, and re run the Set up Support Rules part but it doesn’t work. I tried : net start winmgmt in command prompt, then it shows service name is invalid with message more help is available by typing NET HELP MSG 2185 .. after I executed this shown command I got a message : check the spelling of the service or check the configuration information for the
    service using the Service option from Server Manager. Any help will be appreciated .. thanks

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s