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”

On a 64-bit computer, you install an instance of the 32-bit (x86-based) version of Microsoft SQL Server 2008. On the same computer, you install an instance of the 64-bit version of SQL Server 2008. If you then uninstall the 64-bit instance, you receive the following error message when you open SQL Server Configuration Manager:

 

Cannot connect to WMI provider. You do not have permission or the server is unreachable. Note that you can only manage SQL Server 2005 and later servers with SQL Server Configuration Manager.
Invalid namespace [0x8004100e]

This problem also occurs if you uninstall the 32-bit instance, and you then open SQL Server Configuration Manager.

CAUSE:

This problem occurs because the WMI provider is removed when you uninstall an instance of SQL Server 2008. The 32-bit instance and the 64-bit instance of SQL Server 2008 share the same WMI configuration file. This file is located in the %programfiles(x86)% folder.

WORKAROUND:

To work around this problem, type the following command, in cmd with Administrative rights, and then press ENTER:

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

 

Note For this command to succeed, the sqlmgmproviderxpsp2up.mof file must be present in the %programfiles(x86)%\Microsoft SQL Server\100\Shared folder. If the file is not in this location, please change to the correct one.

 


 


 

After this command run successfully, you can now open the SQL Server Configuration Manager

 


 

More info:

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/kb/956013

About João Carlos Dias

Senior Consultant at InfraHouse P/S
This entry was posted in Uncategorized. Bookmark the permalink.

6 Responses to 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”

  1. We’re a bunch of volunteers and opening a new scheme in our community. Your site provided us with valuable info to work on. You’ve done a formidable process and our whole
    neighborhood will be thankful to you.

  2. Werner says:

    I do not even know how I stopped up here, but I thought this put
    up used to be great. I don’t realize who you might be but certainly you’re going to a well-known blogger in
    the event you are not already. Cheers!

  3. Have you ever thought about writing an ebook or guest authoring on other
    blogs? I have a blog based on the same topics you discuss
    and would love to have you share some stories/information. I know my subscribers would appreciate
    your work. If you’re even remotely interested, feel free to send me an e mail. twitter followers without having offering your username and password or maybe next some others.
    You may buying twitter followers through several vendors at affordable costs.
    Products to be able to buy followers, we could enable you to!

  4. I know this web page offers quality depending articles and
    other information, is there any other web page which offers these kinds
    of information in quality?

  5. Excellent post. I was checking continuously this
    blog and I am impressed! Very helpful info specifically the last part :
    ) I care for such information a lot. I was seeking this certain information for a long time.
    Thank you and best of luck.

  6. owie says:

    Greetings! I know this is kinda off topic but I was wondering if you
    knew where I could find a captcha plugin for my
    comment form? I’m using the same blog platform as yours and I’m having trouble finding one?
    Thanks a lot!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s