SQL Server Configuration Manager - Cannot connect to the WMI Provider

Hi Folks,

I use SQL Server 2008 R2 on top of Windows Server 2008. Once I wanted to open up the SQL Server Configuration manager and ended up getting an error.

[Navigation]

It said "Cannot connect to the WMI Provider". The full error message is as below:

The operating system installed is 64 bit. The reason behind this issue is that the WMI Provider is removed. One way in which this could happen is, when you install an instance of the 32 bit version of SQL Server and an instance of the 64 bit version of  SQL Server in the same machine and then remove any of the instances afterwards. Both instances share the same WMI configuration file. When either of the instance are removed the WMI configuration file is removed.

As a workaround, type in the following command in the command prompt:

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

Obviously, for this command to take effect the "sqlmgmproviderxpsp2up.mof file" should be available in the specified folder location :) 

And here's what you get when you execute the command

And there you have it ! Issue solved ! You could go back and view the configuration manager