Submit a ticketCall us
Home > Success Center > Server & Application Monitor (SAM) > SAM - Knowledgebase Articles > Appinsight for SQL: Monitors in Unknown state

Appinsight for SQL: Monitors in Unknown state

Created by Chris Foley, last modified by MindTouch on Jun 23, 2016

Views: 3,706 Votes: 2 Revisions: 4


This article provides brief information and steps to resolve the issue when some components of AppInsight for SQL appear to be  in unknown state: 

  • Performance Counter Monitors
  • Windows Service Monitors
  • Windows Event Log Monitor


  • SAM version 6.0 or later
  • All versions of Windows



The error can occur when any of the following happens to AppInsight for SQL Template:

  • Manually assigned to a Node using a polling method of SNMP.
  • The Application is given a SQL Account instead of a Windows account.  As a result, SAM has no Windows account to use to perform RPC or WMI queries.


Use any of the following workarounds:


  1. Instead of manually assigning the Appinsight for SQL Template to the Node, discover it via the Node's "List Resources" interface. This method will detect that no Windows Authentication is available and automatically disable the Monitors mentioned above.


  1. Give the Appinsight for SQL a Windows account with Admin rights to the system hosting the SQL Server installation.


  1. Manually assign the Appinsight for SQL Template to the Node, however, edit the settings for the resulting Application and disable the above-mentioned Component.  Note: At the time of this writing, the Windows Event Log Monitor does not have an option to disable it.





Last modified