Submit a ticketCall us

Training ClassSign up for Network Performance Monitor (NPM) and Scalability instructor-led classes

Attend our instructor-led classes, provided by SolarWinds® Academy, to discuss the more advanced monitoring mechanisms available in NPM as well as how to tune your equipment to optimize its polling capabilities. NPM classes offered:
NPM Custom Monitoring and Polling
Orion Platform Scalability

Reserve your seat.

Home > Success Center > Server & Application Monitor (SAM) > SAM - Knowledgebase Articles > Logon errors in SQL Logs on a monitored SQL server

Logon errors in SQL Logs on a monitored SQL server

Table of contents
Created by William Muhle, last modified by Craig Healy on Nov 05, 2018

Views: 1,550 Votes: 3 Revisions: 7

Overview

This article provides brief information on the following error appearing within your SQL logs on a monitored SQL server despite the application monitor being able to poll the server without issues:

 

20151022 11:30:46.70 Logon Error: 18456,
Severity: 14, State: 6.


20151022 11:30:46.70 Logon Login failed for
user 'DOMAIN\USERNAME'. Reason: Attempting to use an NT account name with SQL
Server Authentication.

Environment

Any SQL server monitored by SAM

Detail

The reason for the errors is SAM will attempt log into the SQL server via both Windows credentials and SQL credentials.  This is by design and will cause a login failure for the version of authentication that it is not using.

 

Attempt, NT, NT account, SQL Server, Authentication, message, log, logon, 18456, login, AppInsight

Last modified

Tags

Classifications

Public