SQL Server – Error while opening SQL Server Configuration Manager – Fixed

Hi Friends,

Today I again experienced the same old frustrating error while opening SQL Server Configuration Manager on one of the SQL Servers. Refer the screenshot below.

1_Error_while_opening_SQL_Server_Configuration_Manager_Fixed

The error says:  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 [0x8004100]  Adding text so that you can find it through search engine when you face this issue. 

Now as the error mentioned: everybody will directly jump to services.msc console to check if WMI service (Windows Management Instrumentation) is running or not. Even i checked the same thing, It was running. The next step you might want to check is if WMI Service is running properly or not. Etc

Now Please stop validating your WMI Service, the issue is not related to WMI connectivity\service; having said that, it is related to WMI only but the error message is not pointing to the underlying issue.

The issue is with the WMI provider for your SQL instance. Basically what happens “whenever you uninstall any SQL instance from a Server it somehow also removes WMI provider – but this becomes a problem when you have multiple instances on a Server and you uninstall one of them. “

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.

So what’s the solution\Fix?
The solution is a mof file which contains all configuration settings which regenerates WMI Provider for SQL Server, All you need to do is just locate the below mentioned folder on your server and issue the command with correct path.

mofcomp c:\program files (x86) \Microsoft SQL Server\100\Shared\sqlmgmproviderxpsp2up.mof"

This is how it will look once you issue this command on a Command Prompt.

2_Error_while_opening_SQL_Server_Configuration_Manager_Fixed

That’s it once you see “Done!” On the command Prompt, everything is fixed and back to normal.

Now you can open your SQL Server Configuration Manager and work as you wish.

Do let me know if there is any other way to fix this; I’ll add that to my knowledge.

Enjoy!

 

Regards

Sarabpreet Anand

Like us on FaceBook Follow us on Twitter | Join the fastest growing SQL Server group on FaceBook

Follow me on Twitter  |  Follow me on FaceBook

Data Platform Virtual Summit 2020

Subscribe to SQLServerGeeks YouTube channel. If you want more learning content in your inbox, subscribe to SQLServerGeeks Bulletin.

SQLServerGeeks YouTube | SQLServerGeeks Bulletin | SQLServerGeeks Twitter

3 Comments on “SQL Server – Error while opening SQL Server Configuration Manager – Fixed”

  1. This did not work for me. Everyone keeps saying the same thing but on mine, I get an error when I try to do this.

    I am logged in through an RDP connection as the Administrator

    Here is the error message that I get.

    Microsoft 32-Bit MOF Complier Version 5.2.3790.3959
    Copyright Microsoft Corp. 1997-2001. All rights reserved
    Parsing MOF file: sqlmgmproviderxpsp2up.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 4 – 7:
    Error Number: 0x8004100a, Facility: WMI
    Description: Critical error
    Complier returned error 0x8004100a

Leave a Reply

Your email address will not be published. Required fields are marked *