What are the Authentication Modes in SQL Server?

SQL Server supports two security (authentication) modes:

Windows Authentication and Mixed mode

1. Windows Authentication mode connects to an instance of SQL Server through a Windows NT 4.0 or Windows 2000 user account.

2. Mixed mode (Windows Authentication and SQL Server Authentication) connect to an instance of SQL Server by using either Windows Authentication or SQL Server Authentication.