A Lightweight Error Audit with Extended Events
Capture error_reported in Extended Events, filter the backup and informational noise at the session, and triage real errors by severity.
Obtaining machine names for failed logins
The SQL Server error log contains invaluable details about failed logins, but only if you enable login auditing. Once enabled, the error log will provide the details of logins that failed including the name of…