Skip to content
CyberSimStart training

Windows Application log

18456 Login failed for user.

SQL Server rejected a login. The reason is in the message and in the error state in the SQL Server error log (state 8: wrong password, state 5 or 2: unknown user).

Fields to read

FieldWhat it tells you
LoginNameThe SQL Server login that was tried.
ReasonWhy it failed, for example "Password did not match that for the login provided."
ClientIPThe client address, as [CLIENT: …] in the message.

Normal

  • An application with an outdated password in its connection string, failing on every retry until someone fixes it.

Suspicious

  • Failures for many logins (sa among them) from one address: password guessing against the database.

Find it

Microsoft Sentinel (KQL)

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

Splunk (SPL)

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

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

Source: Microsoft Learn: MSSQLSERVER_18456