Ask the Community
Groups
SQL Server is not showing up as an application in the user interface. - Connect IT Community | Kaseya
<main> <article class="userContent"> <h2 data-id="summary"><strong>SUMMARY</strong></h2> <p>SQL Server is not showing up as an application in the user interface.</p> <h2 data-id="issue"><strong>ISSUE</strong></h2> <p></p> <h3 data-id="purpose">Purpose</h3> <p>To re-install MOF for SQL Server.</p> <h3 data-id="description">Description</h3> <p>SQL Server is not showing up as an application in the user interface.</p> <h3 data-id="cause">Cause</h3> <p>WMI is not interfacing with SQL Server.</p> <h3 data-id="resolution">Resolution</h3> <h3 data-id="mofcomp-programfiles-x86-microsoft-microsoft-sql-server-number-shared-sqlmgmproviderxpsp2up-mof">mofcomp "%programfiles(x86)%\Microsoft\Microsoft SQL Server\NUMBER\Shared\sqlmgmproviderxpsp2up.mof"</h3> <h3 data-id="note">***NOTE****</h3> <b>The value of <strong>NUMBER</strong> depends on the version of SQL Server.</b><br> <table><tbody><tr><td colspan="1" rowspan="1">Microsoft SQL Server 2012 - 110</td> <td colspan="1" rowspan="1"> </td> </tr><tr><td colspan="1" rowspan="1">Microsoft SQL Server 2008 R2 - 100</td> <td colspan="1" rowspan="1"> </td> </tr><tr><td colspan="1" rowspan="1">Microsoft SQL Server 2008 - 100</td> <td colspan="1" rowspan="1"> </td> </tr><tr><td colspan="1" rowspan="1">Microsoft SQL Server 2005 - 90</td> <td colspan="1" rowspan="1"> </td> </tr></tbody></table><b>After you run the Mofcomp tool, restart the WMI service for the changes to take effect. The service name is Windows management Instrumentation.</b> <h3 data-id="third-party-sources">Third-Party Sources</h3> <p><a href="/home/leaving?allowTrusted=1&target=http%3A%2F%2Fsupport.microsoft.com%2Fkb%2F956013">http://support.microsoft.com/kb/956013</a></p> <p><b>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.</b></p> <div> </div> </article> </main>