Search This Blog

Monday, December 31, 2007

MSSQL 2005 Installation

I was trying to install mssql2005 advanced express edition, but i ran into some problem, it was continuously spiting error at me, the error was this..

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

i was just frustrated, coz this same error occured when i had tried to install it some half year ago. but still the same error haunting after these long times, It was a wmi problem and after some nearly an hours search with google, i got the solution... i had to run a batch file and bingo the WMI error was fixed. actually it is something like refreshing the links and associations that is what the batch file does. the batch file which i used is as follows..

@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

No comments:

Post a Comment