Fix SQL Configuration Manager Cannot Connect to WMI Provider

When trying to open MS SQL Server Configuration Manager, a dialog may appear..

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]

 

This is caused by an issue with the compiled SQL Configuration Manager GUI’s communication with WMI.

 

Open a command prompt as administrator

Navigate to your SQL version’s shared directory (cd <version path>):

SQL 2008:  C:\Program Files (x86)\Microsoft SQL Server\90\Shared\
SQL 2008 R2:  C:\Program Files (x86)\Microsoft SQL Server\100\Shared\
SQL 2012:  C:\Program Files (x86)\Microsoft SQL Server\110\Shared\
SQL 2014:  C:\Program Files (x86)\Microsoft SQL Server\120\Shared\

Then run the following command:

mofcomp sqlmgmproviderxpsp2up.mof