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!

Leave a Comment

Your email address will not be published.