Submit a ticketCall us

Have You Auto Renewed? If not, you're missing out.
The SolarWinds Renewal Program comes with a host of benefits including the most recent product updates, 24/7 technical support, virtual instructor-led training and more. Experience all of this with the convenience of Auto Renewal, and never worry about missing any of these great benefits. Learn More.

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: 153 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