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.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...
and SQL Server Configuration Manager should start fine.