Anith Gopal

  I am posting this article on behalf of my teammate Lyudmila.     A new tool to help investigate ‘Login Failed’ errors in SQL Server has been recently implemented and published on CodePlex: http://ssat.codeplex.com/ The tool is implemented in C# and uses xEvents to capture “Login Failed” errors. It also uses security ring buffer information (from sys

Read more here: 
SQL Server Authentication Troubleshooter