Sep 24, 2013

Troubleshoot DiscoverSQL2005DBEngineDiscovery.vbs

How to troubleshoot warning alert in SCOM 2007:

Command executed:

"C:\WINDOWS\system32\cscript.exe" /nologo "DiscoverSQL2005DBEngineDiscovery.vbs" {E71360F6-C12E-8326-4539-FBC9D78862F5} {E6607398-183B-5B70-A183-878016FCF334} sfrfidcprdb002p.domain.name sfrfidcprdb002p.domain.name sfrfidcprdb002p "Exclude:"


Alert Description:

The process started at 5:56:12 AM failed to create System.Discovery.Data, no errors detected in the output. The process exited with 0.


In event log:

DiscoverSQL2008DBEngineDiscovery.vbs : The Query 'select * from SqlService where SQLServiceType ='1'' did not return any valid instances.  Please check to see if this is a valid WMI Query.. Invalid class

Solution:

From a command prompt, browse to the folder “C:\Program Files (x86)\Microsoft SQL Server\100\Shared”
Run mofcomp sqlmgmproviderxpsp2up.mof

No comments:

Post a Comment