Rover12421's Blog

The End.

安装Microsoft SQL Server 2005出错 Error:2147749891 (0×80041003)

想装个Microsoft SQL Server 2005也不容易啊

TITLE: Microsoft SQL Server 2005 Setup
------------------------------

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

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

------------------------------
BUTTONS:

OK
------------------------------

说是什么WMI问题,(WMI是Windows 2K/XP管理系统的核心;对于其他的Win32操作系统,WMI是一个有用的插件。WMI以CIMOM为基础,CIMOM即公共信息模型对象管理器 (Common Information Model Object Manager),是一个描述操作系统构成单元的对象数据库,为MMC和脚本程序提供了一个访问操作系统构成单元的公共接口。有了WMI,工具软件和脚本 程序访问操作系统的不同部分时不需要使用不同的API;相反,操作系统的不同部分都可以插入WMI,如图一所示(该图来自MSDN),工具软件和WMI可 以方便地读写WMI。)于是找了个重新安装WMI的脚本

FIXWMI.CMD

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
@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

可还是不行,看到有人说查看wbem日志
C:WINDOWSsystem32wbemLogswmiprov.log

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
(Fri Nov 14 17:37:21 2008.120156) : WDM call returned error: 4200
(Fri Nov 14 17:37:21 2008.120187) : ***************************************
(Fri Nov 14 17:37:21 2008.120187) : Could not get pointer to binary resource for file:
(Fri Nov 14 17:37:21 2008.120187) : C:WINDOWSSystem32driversafd.sys[AfdMofResource](Fri Nov 14 17:37:21 2008.120187) :
(Fri Nov 14 17:37:21 2008.120187) : ***************************************
(Fri Nov 14 18:33:19 2008.120156) : WDM call returned error: 4200
(Fri Nov 14 18:33:19 2008.120171) : ***************************************
(Fri Nov 14 18:33:19 2008.120171) : Could not get pointer to binary resource for file:
(Fri Nov 14 18:33:19 2008.120171) : C:WINDOWSSystem32driversafd.sys[AfdMofResource](Fri Nov 14 18:33:19 2008.120171) :
(Fri Nov 14 18:33:19 2008.120171) : ***************************************
(Sat Nov 15 08:30:15 2008.120156) : WDM call returned error: 4200
(Sat Nov 15 08:30:15 2008.120187) : ***************************************
(Sat Nov 15 08:30:15 2008.120187) : Could not get pointer to binary resource for file:
(Sat Nov 15 08:30:15 2008.120187) : C:WINDOWSSystem32driversafd.sys[AfdMofResource](Sat Nov 15 08:30:15 2008.120187) :
(Sat Nov 15 08:30:15 2008.120187) : ***************************************
(Sat Nov 15 08:30:50 2008.155046) : Received Event
(Sat Nov 15 21:41:11 2008.120234) : WDM call returned error: 4200
(Sat Nov 15 21:41:11 2008.120265) : ***************************************
(Sat Nov 15 21:41:11 2008.120265) : Could not get pointer to binary resource for file:
(Sat Nov 15 21:41:11 2008.120265) : C:WINDOWSSystem32driversafd.sys[AfdMofResource](Sat Nov 15 21:41:11 2008.120265) :
(Sat Nov 15 21:41:11 2008.120265) : ***************************************
(Mon Nov 17 09:06:25 2008.120156) : WDM call returned error: 4200
(Mon Nov 17 09:06:25 2008.120171) : ***************************************
(Mon Nov 17 09:06:25 2008.120171) : Could not get pointer to binary resource for file:
(Mon Nov 17 09:06:25 2008.120171) : C:WINDOWSSystem32driversafd.sys[AfdMofResource](Mon Nov 17 09:06:25 2008.120171) :
(Mon Nov 17 09:06:25 2008.120171) : ***************************************
(Mon Nov 17 09:07:23 2008.178421) : Received Event
(Mon Nov 17 09:16:09 2008.120640) : WDM call returned error: 4200
(Mon Nov 17 09:16:09 2008.120656) : ***************************************
(Mon Nov 17 09:16:09 2008.120656) : Could not get pointer to binary resource for file:
(Mon Nov 17 09:16:09 2008.120656) : C:WINDOWSSystem32driversafd.sys[AfdMofResource](Mon Nov 17 09:16:09 2008.120656) :
(Mon Nov 17 09:16:09 2008.120656) : ***************************************
(Tue Nov 18 08:59:46 2008.120843) : WDM call returned error: 4200
(Tue Nov 18 08:59:46 2008.120953) : ***************************************
(Tue Nov 18 08:59:46 2008.120953) : Could not get pointer to binary resource for file:
(Tue Nov 18 08:59:46 2008.120953) : C:WINDOWSSystem32driversafd.sys[AfdMofResource](Tue Nov 18 08:59:46 2008.120953) :
(Tue Nov 18 08:59:46 2008.120953) : ***************************************
(Tue Nov 18 10:15:39 2008.120656) : WDM call returned error: 4200
(Tue Nov 18 10:15:39 2008.120781) : ***************************************
(Tue Nov 18 10:15:39 2008.120781) : Could not get pointer to binary resource for file:
(Tue Nov 18 10:15:39 2008.120781) : C:WINDOWSSystem32driversafd.sys[AfdMofResource](Tue Nov 18 10:15:39 2008.120781) :
(Tue Nov 18 10:15:39 2008.120781) : ***************************************
(Wed Nov 19 09:16:21 2008.124437) : WDM call returned error: 4200
(Wed Nov 19 09:16:22 2008.124812) : ***************************************
(Wed Nov 19 09:16:22 2008.124812) : Could not get pointer to binary resource for file:
(Wed Nov 19 09:16:22 2008.124812) : C:WINDOWSSystem32driversafd.sys[AfdMofResource](Wed Nov 19 09:16:22 2008.124812) :
(Wed Nov 19 09:16:22 2008.124812) : ***************************************
(Wed Nov 19 09:16:23 2008.126484) : Received Event
(Wed Nov 19 17:02:43 2008.120625) : WDM call returned error: 4200

都是这样的错误就不全帖了。。。
貌似是不能读取某个文件,于是把drivers和wbem目录全设置成everyone完全控制权限,结果还是一样。真是够郁闷的。
查看错误日志也全是WinMgmt事件警告,ID就多了,35,40,63,5603.问题真多。去官网搜索,看了半天,也没把问题解决,时间啊~~,毕竟还是看到点希望,估计是NET Framework的问题,一想这就怀疑是VS2008的问题了,重装VS2008,真是要命,大家伙啊。
重新装好VS2008后,重启,然后用系统自带的升级程序升级,汗,一个231M的NET Framework补丁(dotnetfx35.exe),不管了,先打补丁。
一切完事再来安装Microsoft SQL Server 2005,没事了。。。
问题解决,不是出在VS2008上就是NET Framework的补丁上了。

Comments