DataZip

Azure SQL DBA Tools: Connection Failure Logs

Tung Dang
Feb 05, 2025By Tung Dang

Here's a simple query you can run within the master database on any Azure SQL Server to view all server connections that failed.  The details about the connection failure isn't too specific but a DBA can use it to generally find the root cause of a connection failure.

SELECT database_name
     , start_time
     , end_time
     , event_category
     , event_type
     , event_subtype
     , event_subtype_desc
     , severity
     , event_count
     , description
FROM master.sys.event_log
WHERE event_type = 'connection_failed'