Cannot connect to WMI provider – Sql Server Configuration Manager 2008 R2

Reason :

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

Resolution:

Goto ‘Start’ – ‘All Program’ – ‘Accessories’, right click on ‘Command Prompt’ and select ‘Run as Administrator’.

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

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

TIP: Whenever you run ‘Command Prompt’, always ‘Run as Administrator’.

Case CLOSED!