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).
- ApplicationLog
- MSSQLSERVERSource
- 1Cases and alerts that use it
Fields to read
| Field | What it tells you |
|---|---|
LoginName | The SQL Server login that was tried. |
Reason | Why it failed, for example "Password did not match that for the login provided." |
ClientIP | The 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 == 18456Splunk (SPL)
index=wineventlog source="XmlWinEventLog:Application" EventCode=18456Table, index and source names as CyberSim uses them; your workspace may name them differently.
Where you meet it in CyberSim
Alerts in the shift
- Repeated database login failures