SQL Server is not showing up as an application in the user interface.

SUMMARY

SQL Server is not showing up as an application in the user interface.

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.
 
Microsoft SQL Server 2012  -       110 
Microsoft SQL Server 2008 R2  -  100 
Microsoft SQL Server 2008  -       100 
Microsoft SQL Server 2005  -         90 
After you run the Mofcomp tool, restart the WMI service for the changes to take effect. The service name is Windows management Instrumentation.

Third-Party Sources

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.

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Contact us