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.

Hi All,

In this post we will see an issue about When you try to open SQL Configuration Manager and if you get an error like “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 [0x8004100]

Cause:

This problem occurs because the WMI provider is removed when you uninstall an instance of SQL Server. The 32-bit instance and the 64-bit instance of SQL Server share the same WMI configuration file. This file is located in the %programfiles(x86)% folder.

In my case I am using SQL Server 2012  and the location as follows ,

C:\Program Files <x86>\Microsoft SQL Server\110\Shared folder.

Resolution this problem, We have to open a command prompt, type the following command, and then press ENTER.

mofcomp 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.

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, make sure to restart the WMI(Windows Management Identity Service) service for the changes to take effect.

Once this is done you will be able to open the SQL Configuration Manager Console.

Thanks.

Related Post