Thursday, 18 July 2013

The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine: FIX



While installing SQL you may experience this error,  I googled the same but found many scripts which won’t works but the given below works fine.
----------------------------------------------
@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
 -----------------------------------------------

A) Open a notepad
B) Copy and paste the above scripts to that
C) Save as FIXWMI.CMD (name can be anything, extension should be cmd)
D) Run the script (double click will do)
E)It will ask for a confirmation, allow that.
F) It will take some time to finish.

G) After finishing try, the error might have gone.

0 comments:

Post a Comment