Thursday, October 06, 2016

SQL Server Configuration Manager - Invalid class [0x80041010]

This is the second blog post that I wrote about troubleshooting of SQL Server Configuration Manager. This time, or a forgotten number of times, I start Configuration Manager but it returns an error like below:

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]

Sounds like the code [0x80041010] is a good starting point. Did a bit of research, and found Michael Aspengren's blog post about it (see reference below).

So first, open the command prompt with Run as administrator and navigate to the C:\Program Files(x86)\Microsoft SQL Server\100\Shared\

then run the following command: mofcomp sqlmgmproviderxpsp2up.mof

The output should look like these:

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…
Done!

And Wola!! SQL Server Configuration Manager should starts without a problem!! Thanks again, Mike!! :)

Reference
"SQL Server Configuration Manager" gives "Invalid class [0x80041010]” when starting.