操作系统:Windows XP SP3
数据库软件:SQL SERVER 2005
返回错误:安装到复制文件界面,报错,安装程序退出。
查看事件管理器:显示错误 WMI ADAP 无法为性能库 MSSQLSERVER 创建对象 Win32_PerfFormattedData_MSSQLSERVER_SQLServerBufferManager,原因是返回了错误 0x80041002,错误如下。
解决办法:
将下列文件文本存储为FIXWMI.CMD,然后执行后,再次安装SQL Server2005。
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