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

I was excited to install SQL Server 2005 Beta 2 on my Win2k3 Server.

The 2.0 Framework, SNAC, and Support files appear to go on fine.  Our install failed at the point where the Setup Consistency Checker (SSC) was supposed to run.  

Microsoft SQL Server 2005 Beta 2 Setup

The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine <machineName> Error:2147749907 (0x80041013).

I also saw this in a log file;

Windows Management Instrumentation (WMI) is not functioning properly.  Further checks cannot be performed. Action: Please make sure Windows Management Instrumentation (WMI) is functioning properly.  The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine <yourMachinename> Error:2147749890 (0x80041002).

First, to get out on the table the environement:

Server:                                   Win2003 server Enterprise

Yukon:                                    SQL Server 2005 Beta 2

Other installed programs:      Only SQL 2000 at the SP3a level

To fix this ‘kind’ of error, there are some classic files to look for, and rename them.  Of course these only exist if a Yukon install had been performed or even tried.  And in my case Yukon had never been attempted, but nevertheless I checked to make sure these files were not present, and they were not. 

mmc.exe.manifest

w3wp.exe.manifest

inetinfo.exe.manifest

dllhost.exe.manifest

wmiprvse.exe.manifest

Next, there are a bunch of things that can get messed up on a server’s OS that could later cause WMI problems, here are some of the usual suspects that you can run to fix this type of problem, but in my case they did not help.

Start|Run|Command

   secedit /configure /cfg %windir%\repair\secsetup.inf /db secsetup.sdb /verbose

   Mofcomp.exe %windir%\system32\wbem\cimwin32.mof

   Regsvr32 wbemupgd.dll

   regsvr32 wbemsvc.dll

At this point I was desperate, so I actually uninstalled and reinstalled the Windows Server 2003 SP1 and reinstalled it, but alas, to no avail.  Remember, for Itanium boxes, you must have SP1 on if you want to install SQL 2005.  But the reinstall did not help.  Bummer.

But then Niko from the SQL Server Setup Team came to the rescue and suggested I try this:

   wmiprvse /regserver

or

try this

The cause of this error is a corrupt install of WMI, caused by upgrading Windows Server 2003 to SP1 build 1277. To fix this issue, copy the following into notepad and save it with either a .cmd or .bat extension. Then run the script to re-install WMI:

%SYSTEMDRIVE%
CD %windir%\system32\wbem
Mofcomp.exe cimwin32.mof
Regsvr32 /s wbemupgd.dll
Regsvr32 /s wbemsvc.dll
wmiprvse /regserver

And lo and behold, my Yukon (SQL Server 2005) went on smooth as glass.  Turns out some WMI folks over in Microsoft passed that little tid-bit onto him.  

I found out that this is an active bug in Windows Server 2003 for RTM to SP1 upgrades where it screws up WMI, so as a public service, I want to pass this on.  

I’m sure MS will get this straightened out before they go golden with SP1.  

Thankx to www.MSNSearch.com

Advertisements
This entry was posted in Uncategorized. Bookmark the permalink.

4 Responses to The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine Error:2147749907 (0x80041013).

  1. shashi says:

    Hi first of all thanks to you, for giving such a magic solution of WMI configuration problem while installing sql server 2005.
     
    The following code works in my case. After executing this code I re-start my setup. It really works…… I think this is the best solution of this problem
     
    %SYSTEMDRIVE%CD %windir%\\system32\\wbemMofcomp.exe cimwin32.mofRegsvr32 /s wbemupgd.dllRegsvr32 /s wbemsvc.dllwmiprvse /regserver
     
    Thanks & Regards
    shashi kant chauhan
     

  2. Unknown says:

    clong512 gouliu666 peons4hire wow gold wow gold wow gold peons4hire 留学 英国留学 留学英国 美国留学 peons4hire 黑马股 黑马股 peons4hire 黑马股推荐 黑马股推荐 peons4hire 大智慧 大智慧 peons4hire 水泵 水泵 FAG轴承 FAG轴承 peons4hire peons4hire 离心泵 离心泵 离心泵 peons4hire 液下泵 液下泵 peons4hire 转子泵 转子泵 TIMKEN轴承 TIMKEN轴承 深圳网页设计 深圳网页设计 英语口语 英语口语 中高年 転職 阀门 阀门 wow gold wow gold wow gold world of warcraft gold world of warcraft gold thsale thsale thsale

  3. Unknown says:

    dg525d kut65ds wow gold wow gold wow gold wow gold 全教振 全教振 SKF轴承 SKF轴承 NSK轴承 NSK轴承 移民德国 新加坡签证 澳洲签证 日本签证 干洗店设备价格 干洗店设备 股票软件 股票软件 大智慧 大智慧 深圳网页制作 深圳网页制作 中高年 転職 中高年 転職 賃貸 賃貸 不動産 不動産 炒股软件 炒股软件 进口轴承 进口轴承 wow gold wow gold wow gold wow gold wow gold wow gold wow gold wow gold wow gold wow gold wow gold wow gold

  4. Unknown says:

    sfggor1 tyjturyhr AoC gold AoC gold AoC gold AoC gold 连锁店 连锁店 连锁店 水洗厂 水洗厂 水洗厂 烘干机 烘干机 烘干机 去渍台 去渍台 去渍台 开干洗店 开干洗店 开干洗店

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