When you try to open SQL Server configuation Manager, you find the following error:
"Cannot connect to WMI provider. Permission or the server is unreachable. Note This can only manage SQL Server 2005 and later servers with SQL Server Configuration Manager. "
Invalid class [0x8004100]
Don't panic, this is because the WMI provider of your SQL instance was accidentally removed. Either the 32-bit SQL instance or the 64-bit SQL instance references the same WMI settings (this setting is in: "%programfile (x86)%\microsoft SQL server\[version]\shared\ Sqlmgmproviderxpsp2up.mof ")
So just go into the%programfile (x86)%\microsoft SQL server\[version]\shared directory and execute
Mofcomp sqlmgmproviderxpsp2up.mof
View Code
Then restart SQL Server Configuration Manager.
The corresponding relationship between [version] and SQL Server is as follows:
SQL Server Version | [Version]
----------------------------------|----------
Microsoft SQL Server 2012 | 110
Microsoft SQL Server R2 | 100
Microsoft SQL Server 2008 | 100
Microsoft SQL Server 2005 | 90
How to resolve the SQL error "Cannot connect to WMI provider"