KB: Event 4001 in the Operations Manager log during SQL Server 2012 monitoring

[System-Center-Team]

First published on TECHNET on May 12, 2014

Here’s a quick note on a new KB article we published:

When you are monitoring a Microsoft SQL Server 2012 computer that has the System Center 2012 Operations Manager agent installed, you notice that event 4001 is logged in the Operations Manager log, as follows:

Log Name: Operations Manager
Source: Health Service Script
Date:
Event ID: 4001
Task Category: None
Level: Error
Keywords: Classic
User: N/A Computer: SQLServer01.domain.com
Description: GetSQL2012SPNState.vbs : The Query 'SELECT ProtocolName FROM ServerNetworkProtocol where Enabled = true and InstanceName = 'SQLSERVERINSTANCE'' did not return any valid instances. Please check to see if this is a valid WMI Query. Invalid class

You may also find that invalid class error 0x80041010 is returned when you try to open SQL Server Configuration Manager, as in the following error message:

Cannot connect to WMI provider. You do not have permission or the server is unreachable. Note that you can only manage SQL Server 2005 and later servers with SQL Server Configuration Manager. Invalid class [0x80041010]

This issue may occur if there are SQL classes that are missing or are not registered in Windows Management Instrumentation (WMI) on the computer that's running SQL Server.

For all the details and a resolution, please see the following:

KB2962161 - Event 4001 in the Operations Manager log during SQL Server 2012 monitoring ( http://support.microsoft.com/kb/2962161 )

J.C. Hornbeck | Solution Asset PM | Microsoft GBS Management and Security Division

Get the latest System Center news on Facebook and Twitter :

System Center All Up: http://blogs.technet.com/b/systemcenter/
System Center – Configuration Manager Support Team blog: http://blogs.technet.com/configurationmgr/
System Center – Data Protection Manager Team blog: http://blogs.technet.com/dpm/
System Center – Orchestrator Support Team blog: http://blogs.technet.com/b/orchestrator/
System Center – Operations Manager Team blog: http://blogs.technet.com/momteam/
System Center – Service Manager Team blog: http://blogs.technet.com/b/servicemanager
System Center – Virtual Machine Manager Team blog: http://blogs.technet.com/scvmm

Windows Intune: http://blogs.technet.com/b/windowsintune/
WSUS Support Team blog: http://blogs.technet.com/sus/
The AD RMS blog: http://blogs.technet.com/b/rmssupp/

App-V Team blog: http://blogs.technet.com/appv/
MED-V Team blog: http://blogs.technet.com/medv/
Server App-V Team blog: http://blogs.technet.com/b/serverappv

The Forefront Endpoint Protection blog : http://blogs.technet.com/b/clientsecurity/
The Forefront Identity Manager blog : http://blogs.msdn.com/b/ms-identity-support/
The Forefront TMG blog: http://blogs.technet.com/b/isablog/
The Forefront UAG blog: http://blogs.technet.com/b/edgeaccessblog/