Submit a ticketCall us
Home > Success Center > Log & Event Manager (LEM) > LEM - Knowledgebase Articles > Unable to receive any SQL Server events from the Windows Application event log

Unable to receive any SQL Server events from the Windows Application event log

Created by Jason Dee, last modified by MindTouch on Jun 23, 2016

Views: 1,191 Votes: 1 Revisions: 4

Overview

This article provides brief information and steps to resolve the issue when you are not receiving any SQL Server events from the Windows Application log.

In the Windows Application Log on your SQL Server, there may be events from SQL Server (in the Source column) that are currently not logging to LEM.

 

Environment

  • All LEM versions
  • Windows Server with SQL Server and a LEM Agent installed

 

Cause 

SQL Server Application Log events require an additional connector to be configured.

 

Resolution

  1. In the web console, go to Manage > Nodes.
  2. Find the node with SQL Server installed, click its gear icon, and select Connectors.
  3. Find MSSQL 2000 Application Log connector, click its gear icon, and select New.
  4. Save the connector with the default settings.
  5. Click the gear icon and select Start.

 

This will allow the SQL Server events in Application Log to be parsed and stored in LEM.

Note that even though the connector says "MSSQL 2000", it applies to every version of SQL Server.

 

 

 

 

Last modified

Tags

Classifications

Public