Skip to content
CyberSimStart training

Windows Application log

18454 Login succeeded for user. Connection made using SQL Server authentication.

A SQL Server login with SQL Server authentication succeeded. It is only logged when login auditing records successful logins.

Fields to read

FieldWhat it tells you
LoginNameThe login.
ClientIPThe client address.

Normal

  • Applications connecting with their own login, from their own servers.

Suspicious

  • A success right after a run of 18456 failures from an address that is not an application server.

Find it

Microsoft Sentinel (KQL)

Event
| where EventLog == "Application" and Source == "MSSQLSERVER" and EventID == 18454

Splunk (SPL)

index=wineventlog source="XmlWinEventLog:Application" EventCode=18454

Table, index and source names as CyberSim uses them; your workspace may name them differently.

Where you meet it in CyberSim

Alerts in the shift

Other Application events

Microsoft Learn has no page of its own for this event; the description follows the event’s message text.