Understanding Kerberos and NTLM authentication in SQL Server Connections

In this post, I focus on how NTLM and Kerberos are applied when connecting to SQL Server 2005 and try to explain the design behavor behind several common issues that customers frequently hit. On this page: Kerberos VS NTLM. Requirements for Kerberos and NTLM in SQL Connections. When are Kerberos and NTLM are applied when…