Another Uninstalling problem!

When I am trying to uninstall SQL Server 2005 Express on XP Home I get the following error message:

The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine MARTINS Error:2147749896 (0x80041008).

I have tried restarting the WMI service but that doesn't help. Any ideas?

This looks like a problem with WMI on your computer. Check out the following:

WMI Isn't Working

WMI Diagnosis Utility

This should help you determine what is wrong with WMI and help you fix it.

Regards,

Mike Wachal
SQL Express team

-
Mark the best posts as Answers!

|||Cheers Mike - Running that diag util that you posted says that I have missing files. How would I go about fixing that?

Here is the log file anyway: Log File|||

There seem to be a number of solutions hanging around for this issue, I've picked the one that seems most straight forward. Just copy the following into notepad and save it as either .cmd or .bat and then run the script. This should hopefully replace the files.

Let me know either way...

-- script

%SYSTEMDRIVE%
CD %windir%\system32\wbem
Mofcomp.exe cimwin32.mof
Regsvr32 /s wbemupgd.dll
Regsvr32 /s wbemsvc.dll
wmiprvse /regserver

end script

Source: http://blogs.msdn.com/jpapiez/archive/2004/12/09/279041.aspx

Mike

|||Here is the output of that batch file:

C:\WINDOWS\system32\wbem>Mofcomp.exe cimwin32.mof
Microsoft (R) 32-bit MOF Compiler Version 5.1.2600.2180
Copyright (c) Microsoft Corp. 1997-2001. All rights reserved.
Parsing MOF file: cimwin32.mof
MOF file has been successfully parsed
Storing data in the repository...
An error occurred while opening the namespace for object 1 defined on lines 8
11:
Error Number: 0x80070005, Facility: Win32
Description: Access is denied.
Compiler returned error 0x80070005
C:\WINDOWS\system32\wbem>Regsvr32 /s wbemupgd.dll

C:\WINDOWS\system32\wbem>Regsvr32 /s wbemsvc.dll

C:\WINDOWS\system32\wbem>wmiprvse /regserver
C:\WINDOWS\system32\wbem>|||

I assume that you're still not able to uninstall, right?

The final part of the 'WMI isn't Working' paper I referenced above has a section on repairing WMI that you should read. If that doesn't solve the problem, you'll really need to contact Windows Support as the article suggests. After to common solutions fail, I'm out of my depth.

Regards,

Mike

|||Yes I am still not able to uninstall. Thanks for the link, if that doesn't work I'm going to try a repair installation of Windows.

Thanks for the help and links.

Analysis Services service won't start

Can anyone point me in the right direction?

I haven't used SSAS in a few months and I went to start the service in SQL Server Configuration Manager and I get an error pop-up message:

The request failed or the service did not respond in a timely fashion. Consult the event log or other applicable error logs for details.

However the event log has no useful info - just says the service started, then it stopped - no error related info. There are no logs generated in ..\MSSQL.1\. Every other service starts - database, SSIS, SSRS, Agent, Browser and FullText.

I'm running Sql Server 2005 (with SP1) on Win XP Pro (SP2). Any help appreciated!

Do you see anything in the System Event log?

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

There were a few Information type events that said that Analysis Services started and it stopped, but no error or warning events.

I got impatient and uninstalled SSAS and re-installed and everything works now.

Analysis Services for dba's?

I know this is a silly question so I apologize in advance. Is the
implementation/ configuration/ design/ loading/ etc. of AS typically the
responsibility of a DBA or a Developer of a company? From the perspective
where there is a definate difference between the two roles of course.
--
SQL2K SP3
TIA, ChrisRChris
I am both at work and I firmly believe the dba is reposnible for the
management of the databases and servers in terms of optimising and load
balancing.
Develpers typically come up with a schema or ER diagrams and run them by the
dba with a view for any further normalisation etc.
But I get to do both in my case.
evan
"ChrisR" <bla@.noemail.com> wrote in message
news:Oi$ZIQl3EHA.1524@.TK2MSFTNGP09.phx.gbl...
> I know this is a silly question so I apologize in advance. Is the
> implementation/ configuration/ design/ loading/ etc. of AS typically the
> responsibility of a DBA or a Developer of a company? From the perspective
> where there is a definate difference between the two roles of course.
> --
> SQL2K SP3
> TIA, ChrisR
>

Analysis Services for dba's?

I know this is a silly question so I apologize in advance. Is the
implementation/ configuration/ design/ loading/ etc. of AS typically the
responsibility of a DBA or a Developer of a company? From the perspective
where there is a definate difference between the two roles of course.
SQL2K SP3
TIA, ChrisR
Chris
I am both at work and I firmly believe the dba is reposnible for the
management of the databases and servers in terms of optimising and load
balancing.
Develpers typically come up with a schema or ER diagrams and run them by the
dba with a view for any further normalisation etc.
But I get to do both in my case.
evan
"ChrisR" <bla@.noemail.com> wrote in message
news:Oi$ZIQl3EHA.1524@.TK2MSFTNGP09.phx.gbl...
> I know this is a silly question so I apologize in advance. Is the
> implementation/ configuration/ design/ loading/ etc. of AS typically the
> responsibility of a DBA or a Developer of a company? From the perspective
> where there is a definate difference between the two roles of course.
> --
> SQL2K SP3
> TIA, ChrisR
>