Question of the 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.