Monday, February 29, 2016

"Cannot connect to WMI provider. You do not have permission or the server is unreachable" in SQL Server

 

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

image

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]

Cause :
An issue with the compiled SQL Configuration Manager GUI’s communication with WMI.

A work around is as follow :

Open a command prompt (elevated, run as administrator)

Then 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\

After that execute the following command :
mofcomp sqlmgmproviderxpsp2up.mof

image

After that reboot the server to get all related services to start.

keywords : 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]; SQL,