Vista - SQL Server 2005 Standard installation error CC WMI

SQL Server 2005 Standard Edition was installed on a dual boot computer under
XP Pro and ran ok.
Installed Vista as a dual boot system on the same computer.
When SQL Server installation was initiated I got a Configuration Checker
error due to WMI.
Microsoft SQL Server 2005 Setup
The SQL Server System Configuration Checker cannot be executed due to WMI
configuration on the machine D975 Error:2147749896(0x80041008)
Error code.
70342
Source: setup.rll
Setup exits.

I have Visual Studio 2005 installed with .net framework 2 SP1 and 3 SP1
I had no WMi issues during the installation under XP Pro.
I unistalled SQL Server under XP Pro using CP ADD/Remove.
I get the same error message during SQL installation under Vista.

I tried searches but so far no luck.
Have you any suggestions?

On Wed, 23 Jan 2008 17:50:41 -0800, Brahman
<Brahman@xxxxxx> wrote:
Go into services and verify that the Windows Management
Instrumentation Service is started. Also, VS2005 usually installs SQL
Server 2005 Express. If it is installed before SQL 2005 Standard,
there could be some problems.

Enter wmimgmt.msc into the run (search box in Vista) box and it should
bringup the WMI console. If it does not or you receive an error, WMI
is broke. Although there are steps to repair it out there (use
Google-fu), I would probably do an in place upgrade (reinstall).

But I do know for a fact that they work perfectly on Vista (SQL Server
2005 needs all of it's service packs, though) when they are loaded.

If the WMI service is fine, uninstall VS2005, SQL server 2005 Express
and reinstall, installing SQL 2005 Standard first.

Thanks Ron
I will try your suggestions and let you know the results

"Ron" wrote:

Ron
I checked services -WMi - started - automatic
Ran wmimgmt.msc Console opens.
Right click WMi Control - Properties
Message -Red Cross WMI error features not available. Upgrade WMI to a newer
build. OK
WMI Control(Local) Properties/General
Failed to connect to <local computer>
because "Error code: 0x8004100A"

Did not try Backup/Restore.

Uninstalled recommened programs.
Tried installation of SQL Server2005 Standard Edition first.
CC gives same WMI error.

CP/Admin Tools/Computer Management/Services and Applications/WMi
Control/Properties
Same error message - Failed to connect to <local computer>

Any suggestions for a "In place install of WMI"
Where is this snap-in available?
How can I correct this error code?

Thanks for your help




"Ron" wrote:

On Sat, 26 Jan 2008 07:58:01 -0800, Brahman
<Brahman@xxxxxx> wrote:
Although I have never had to repair the WMI, I have had to do some
batch file repairs to fix problems with a service required for a
program of mine. Try this:

<quote>
I found this batch file and ran it and it fixed my WMI problems on SQL
Server 2003. Copy this into notepad as save as fixwmi.cmd and then
from a command line run c:\fixwmi.cmd.

It takes several minutes to complete and at points it appears that it
is not running but it is. After it is complete, you see the :END
statement start the SQL server installation again and you should be
fixed.



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
</quote>

Read the forum thread on the following site:
http://forums.microsoft.com/MSDN/Sho...93534&SiteID=1

Then try to install SQL server2005 Standard first.

I tried the script and didn't work, it didn't show error messages nor
anything like it, what I did was kill the service winmgmt, copy the
whole %windir%\system32\wbem folder from another XP machine where I
could install the SQL server and that solve my problem, though the dll's
didn't copy to the destination folder the ones that did the job where
the config files.

Thanks for the guidance, without it I wouldn't be able to solve it.


--
jorian1
------------------------------------------------------------------------
jorian1's Profile: http://forums.techarena.in/members/jorian1.htm
View this thread: http://forums.techarena.in/vista-help/899523.htm

http://forums.techarena.in