Can’t Connect to Configuration Manager [0x8007007e]

I just ran across an error I had never seen before the other day after logging into a server and trying to open SQL Server Configuration Manager I get the following.

SQL Server Configuration Manager

“Cannot connect to WMI provider. You do not have permission or the server is unreachable. Note that you can only manage SQL Server 2005 servers with SQL Server Configuration Manager. The specified module could not be found. [0x8007007e]”

After checking the server error logs and not finding anything I went to my backup DBA. Mr Google. I found the issue posted on MS Connect but it was “Closed as Not Reproducible”. One thing to note several people reported the error after upgrading SQL 2005 to SQL 2008. This server is a clean install of SQL 2008.

Several workarounds were posted but this is the one that worked for me.

C:\>mofcomp “C:\Program Files (x86)\Microsoft SQL Server\100\Shared\sqlmgmproviderxpsp2up.mof

Command Prompt fix

You can read more about it here, but remember it is closed.

http://connect.microsoft.com/SQLServer/feedback/details/443459/cannot-connect-to-wmi-provider-error-0x8007007e#

Cheers!

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