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