This Win 2003 Std Server running Sql Server 2005 std. Everything worked
since I first installed Sql Server on this machine 6 months ago. It had
only 30GB drive and I wanted 500 GB. I did a Windows backup at 2:30 in the
afternoon, took the machine down, installed 500 GB HD, loaded Win 2003 and
upgraded to Win 2003 SP2 which was running on the machine on the old HD, and
retored the backup at 7:00 that evening.

I was finally able to connect with Sql Server Management Studio, but Sql
Server Configuration Manager and Sql server 2005 Surface Area Configuration
can not connect. I get the message:

"Can not connect to WMI Provider. You do not have permission or the server
is unreachable" from Configuration Manager and

"Sql Server WMI provider is not available on Localhost" from Surface Area
Configuration when I try to configure Surface Area Configuration for
Services and Connections.

Obviously something is not lining up and I can not find what I need to do to
fix the WMI provider. Any help would be appreciated.

If it is a 64 bit computer, possibly you have this problem: Error message
when you open SQL Server Configuration Manager in SQL Server 2008: "Cannot
connect to WMI provider. You do not have permission or the server is
unreachable"
http://support.microsoft.com/default...EN-US%3b956013

--
Rick Byham, MSFT
(Implies no warranty or rights)


"Wishard, Douglas" <dwishard (AT) venturemeas (DOT) com> wrote

The solution outlined in this article is mentioned in other articles I have
found. This is a 32 bit machine running 32 bit software. My theory is that
I loaded the OS, and updated it to SP2, then did a restore and something got
trashed.

What does the following command mentioned in your reference do and will it
work for me?

mofcomp "%programfiles(x86)%\Microsoft\Microsoft SQL
Server\100\Shared\sqlmgmproviderxpsp2up.mof"

This is a production database so I do not want to do testing with something
that might not work.

Thanks for your help.


"Rick Byham, MSFT" <rickbyh (AT) microsoft (DOT) com> wrote

Inspecting the registry I find that the file sqlmgmproviderxpsp2up.mof is in
there 6 times as

C:\Program Files\Microsoft SQL Server\90\Shared\sqmgmproviderxpsp2up.mof

with 6 different values. In the folder the file is dated 10/14/2005 and the
sqlmgmprovider.dll is dated 11/25/2008.

Are these the correct files? How can I tell which of the 6 registry values
are correct or are they all correct?

Thanks,

Doug


"Rick Byham, MSFT" <rickbyh (AT) microsoft (DOT) com> wrote

OK,

I used this command and this seemed to fix the problem. Now Configuration
Manager connects and works and Surface Area Configuration for Sevices and
Connections works as well.

This must have been scrambled in the restore. I still have the 6 entries in
the registry for this file and not 7 as I anticipated.

Thanks for the suggestion.


"Wishard, Douglas" <dwishard (AT) venturemeas (DOT) com> wrote