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.
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.
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
Good old mof file recompilation always does the trick 🙂
precisely, without any doubt.
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