In this troubleshooting tip, Ruben talks about fixing the error you might encounter after you install the Management Pack for SQL version 7.0.15.
Introduction
After we updated the MS SQL Management Pack to 7.0.15 several servers threw alerts that monitoring isn’t working any more.
The error message stated that a WMI query did not return any value.
Details
Shortly after we updated the Management Pack to 7.0.15 we received error messages from a couple of SQL Servers.
The WMI query that is triggered by the DiscoverSQL2012DBEngineDiscovery.vbs did not return any valid instances.
Furthermore, on the SQL Server the SQL Server Configuration Manager could not be started anymore and terminated with the error that it could not connect to the WMI provider.
Solution
Rebuilding provider on the affected SQL Servers.
- Start the command prompt (cmd)
- Navigate to (cd) “C:\ProgramFiles(x86)\MicrosoftSQLServer\110\Shared\” where 110 depends on the g the SQL server version installed on that machine
- Run the following command: mofcomp sqlmgmproviderxpsp2up.mof
Hope this helps!
Cheers