What are the two authentication modes in SQL Server?
There are two authentication modes –
Windows Mode
Mixed Mode
Modes can be changed by selecting the tools menu of SQL Server configuration properties and choose security page.