Ok, so it happened to me again today.
I simply wanted to open the SQL Server Configuration Manager.
Start -> Microsoft SQL Server 2008 -> Configuration Tools -> SQL Server Configuration Manager
and was greeted with the following error:
”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 class [0x80041010]”
For some reason I always forget how to fix this. So time to write it down (and share it).Simply start a command prompt (as administrator) and navigate to:
this should give an output like so:
C:\Windows\system32>cd "C:\Program Files (x86)\Microsoft SQL Server\100\Shared\"
C:\Program Files (x86)\Microsoft SQL Server\100\Shared>mofcomp sqlmgmproviderxpsp2up.mofMicrosoft (R) MOF Compiler Version 6.1.7600.16385Copyright (c) Microsoft Corp. 1997-2006. All rights reserved.Parsing MOF file: sqlmgmproviderxpsp2up.mofMOF file has been successfully parsedStoring data in the repository...Done!
and SQL Server Configuration Manager should start fine.
Thanks a lot .. we have experienced similar issue and this article helped me to resolve this..Thanks Michael
thanks for this solution! works for me! :)
Thanks. Come across the same thing on a brand new setup of win2012 and sql2012. This fixed my problem.
Please change the path to "C:\Program Files (x86)\Microsoft SQL Server\110\Shared\" For SQL Server 2012 SP1
I run cm mofcomp sqlmgmproviderxpsp2up.mof success but still not fix this error
Hi I have sql 2008R2 on 64 bit system but do not have the mofcomp sqlmgmproviderxpsp2up.mof file and getting the same errors stated here by others. I can not get the SQL Server Configuration Manager working.
Can someone please post a link to a secure download site for the mop file.
Hi I have sql 2008R2 on 32 bit system but do not have the mofcomp sqlmgmproviderxpsp2up.mof file and getting the same errors stated here by others. I can not get the SQL Server Configuration Manager working.
Thanks Michael you are a life saver,was experiencing the same issue with my 2012 CLUSTER,it works perfect now
If you have a different version i.e. SQL2012, I found the *.mof file in a different directory. In my case C:\Program Files (x86)\Microsoft SQL Server\110\Shared.
Thanks a lot for the tip. This saved me a fair bit of time and headache.
So what do you do when this doesn't work? (Configuration Manager was working until this morning) No uninstall/install since the initial install of 2012 SP1.
I ran the following as Administrator and I still get the error.
C:\Program Files (x86)\Microsoft SQL Server\110\Shared>mofcomp sqlmgmproviderxpsp2up.mof
Microsoft (R) MOF Compiler Version 6.1.7600.16385
Copyright (c) Microsoft Corp. 1997-2006. All rights reserved.
Parsing MOF file: sqlmgmproviderxpsp2up.mof
MOF file has been successfully parsed
Storing data in the repository...
Thanks, used this on a SQL 2012 server, worked like a charm! Thanks for sharing!
C:\Windows\System32\wbem\mofcomp C:\Windows\System32\wbem\mofcomp sqlmgmproviderxpsp2up.mof\sqlmgmproviderxpsp2up.mof
Correct for SQL 2012, run cmd as Admin, paste into command window:
C:\Windows\System32\wbem\mofcomp "C:\Program Files (x86)\Microsoft SQL Server\110\Shared\sqlmgmproviderxpsp2up.mof"