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!

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s