Friday, February 8, 2019

SQL Configuration Manager Cannot Connect to WMI Provider , Error Number [0x80041010]

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


Windows Server 2008 R2 0x80072F8F Windows Activation Error.

  The Windows activation error code 0x80072F8F may occurred while trying to activate Windows 7 or Windows Vista. As Microsoft says the error...