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.
“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
You can read more about it here, but remember it is closed.
Cheers!
