What authentication modes does SQL Server support?

SQL Server supports Windows Authentication and SQL Server Authentication. Windows Authentication uses Windows or Active Directory identities and integrated security. SQL Server Authentication uses a SQL Server login name and password.

An instance configured for Windows Authentication only does not accept SQL-authenticated logins. Mixed Mode allows both. In managed enterprise environments, integrated authentication is often preferred because identity, password policy, and access lifecycle can be centrally managed.