SQL Server - Dedicated Admin Connection

DAC

https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/diagnostic-connection-for-database-administrators?view=sql-server-ver16

Below is the query to capture the log of login failure in SQL Server.

EXEC xp_readerrorlog 0, 1, N'Login Failed', N'', NULL, NULL, N'desc' 

Best Regards

Amit Vaid