Let us continue our question of the day series with day six.

What are the authentication modes available for SQL Server?

There are two authentication modes available:  Windows mode and mixed mode.  In other words, active directory authentication (Windows) and SQL Server (mixed).  There is no option to allow only SQL Server authentication, if you choose mixed mode then you are allowing both options.  Active directory authentication is the more secure of the two options.

Enjoy!