Submit a ticketCall us

Welcome to the NEW Success Center. Search all resources (documentation, videos, training, knowledge base articles) or browse resources by product. If you are unable to find what you are looking for, please contact us at customersuccess@solarwinds.com

 

 

 

 

Home > Success Center > Log & Event Manager (LEM) > 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: 801 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
20:24, 22 Jun 2016

Tags

Classifications

Public