SUMMARY
SQL Server is not showing up as an application in the user interface, or the SQL backups run to 100% then fail.
ISSUE
Purpose
To re-install MOF for SQL Server.
Description
SQL Server is not showing up as an application in the user interface.
Cause
WMI is not interfacing with SQL Server.
Resolution
mofcomp "%programfiles(x86)%\Microsoft\Microsoft SQL Server\NUMBER\Shared\sqlmgmproviderxpsp2up.mof"
***NOTE****
The value of NUMBER depends on the version of SQL Server.
| Version | nnn | MOF |
|---|---|---|
| Microsoft SQL Server 2022 | 160 | sqlmgmprovider.mof |
| Microsoft SQL Server 2019 | 150 | sqlmgmproviderxpsp2up.mof |
| Microsoft SQL Server 2017 | 140 | sqlmgmproviderxpsp2up.mof |
| Microsoft SQL Server 2016 | 130 | sqlmgmproviderxpsp2up.mof |
| Microsoft SQL Server 2014 | 120 | sqlmgmproviderxpsp2up.mof |
| Microsoft SQL Server 2012 | 110 | sqlmgmproviderxpsp2up.mof |
| Microsoft SQL Server 2008 R2 | 100 | sqlmgmproviderxpsp2up.mof |
| Microsoft SQL Server 2008 | 100 | sqlmgmproviderxpsp2up.mof |
| Microsoft SQL Server 2005 | 90 | sqlmgmproviderxpsp2up.mof |
Third-Party SourcesAfter you run the Mofcomp tool, restart the WMI service for the changes to take effect. The service name is Windows management Instrumentation.
http://support.microsoft.com/kb/956013
The SQL application must have SP2 installed, often it's installed but if you check the version numbers they will not match SQL SP2, please have the customer install SP2 again.