Wednesday 28 May 2014

SQL Server Configuration Manager – Cannot connect to WMI provider – Invalid class [0x80041010]


Problem:
I am getting this error message - "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 the SQL Server Configuration Manager. Invalid class [0x80041010]" when trying to launch SQL Server Configuration Manager.



Had an instance been uninstalled? (Not necessarily the one you are connecting too)? If so, the workaround is mentioned below.

Workaround:
To work around this problem, open a command prompt, type the following command, and then press ENTER:

mofcomp "%programfiles(x86)%\Microsoft SQL Server\number\Shared\sqlmgmproviderxpsp2up.mof"

Note For this command to succeed, the Sqlmgmproviderxpsp2up.mof file must be present in the %programfiles(x86)%\Microsoft SQL Server\number\Shared folder.

For executing the command make sure that you have to log in as an administrator.

The value of number depends on the version of SQL Server: nnn

Microsoft SQL Server 2012
110
Microsoft SQL Server 2008 R2
100
Microsoft SQL Server 2008
100
Microsoft SQL Server 2005
90

After you run the Mofcomp tool, restart the WMI service for the changes to take effect. The service name is Windows management Instrumentation.



Warm Regards,

Chhavinath Mishra
Sr. Specialist Database Administrator
MCITP