SQL Server Properties (Security Tab)

This tab contains the following security related options:

Authentication Mode

SQL Server Only	Specify that users can connect to the instance of SQL Server using SQL Server Authentication only (ie users will not be able to connect using a Windows NT account).
Window NT Only	Specify that users can connect to the instance of SQL Server using Windows Authentication only (ie SQL Server logins are disabled).
SQL Server and Windows NT	Specify that users can connect to the instance of SQL Server using SQL Server Authentication and Windows Authentication. This is considered Mixed Mode authentication.

Users who connect through a Microsoft Windows NT 4.0 or Windows 2000 user account can make use of trusted connections in either Windows Authentication or Mixed Mode. When a user connects through a Windows NT 4.0 or windows 2000 user account, SQL Server revalidates the account name and password by calling back to Windows NT 4.0 or Windows 2000 for the information.

Audit Level

None	Disable auditing. This is the default for this setting.
Success	Audit on successful login attempts.
Failure	Audit on failed login attempts.
All	Audit on both successful and failed login attempts.

You can record attempted user accesses as well as other SQL Server log information, and enable auditing for both security modes and you can record information on both trusted and non-trusted connections. Log records for these events appear in the Microsoft Windows application log, the SQL Server error log, or both, depending on how you configure logging for the instance of SQL Server.

If you change the audit level, you must stop and restart the server for the new audit level to take effect.