What is SQL Server Service Principal Name (SPN) and Kerberos authentication?

SPN enables Kerberos authentication for secure delegation and identity validation.

Kerberos authentication uses SPNs to identify services in Active Directory. Without correct SPN registration, SQL Server falls back to NTLM, which lacks delegation support. SPN misconfiguration is a common cause of authentication and performance issues in distributed systems.