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.
- ApplicationLog
- MSSQLSERVERSource
- 1Cases and alerts that use it
Fields to read
| Field | What it tells you |
|---|---|
LoginName | The login. |
ClientIP | The 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 == 18454Splunk (SPL)
index=wineventlog source="XmlWinEventLog:Application" EventCode=18454Table, 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
Other Application events
Microsoft Learn has no page of its own for this event; the description follows the event’s message text.