SQL Server Authentication Troubleshooter

  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… Read more

Enforce Windows Password Policy on SQL Server Logins

If users choose to use SQL login to connect to SQL Server rather than using NT authenticating, it is worth to remind that SQL server does provide the option of enforcing window password policy on SQL logins. When creating a SQL login you can specify CHECK_POLICY=on, which will enforced on this login of the Windows… Read more