Submit a ticketCall us

Webinar: Web Help Desk for HR, Facilities and Accounting Departments
This webinar will focus on use cases for HR, Facilities and Accounting.

Having a unified ticketing and asset management system for all the departments in your company can provide end-users with a seamless experience and make things easier for your IT team. Yet, with different business tasks and objectives, many departments don’t fully understand the capabilities of Web Help Desk and how the software can be customized for effective use in their departments.
Register Now.

Home > Success Center > Server & Application Monitor (SAM) > 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: 462 Votes: 2 Revisions: 4

Overview

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

Environment

  • SAM version 6.0 or later
  • All versions of Windows

 

Cause 

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.

Resolution

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
02:45, 23 Jun 2016

Tags

Classifications

Public