SQL Server Properties (Security Tab)
Use this tab to view or specify the following options.
Options
SQL Server and Windows
Specify that users can connect to the instance of Microsoft® 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.
Windows only
Specify that users can connect to the instance of SQL Server using Windows Authentication only.
None
Disable auditing. This is the default for this setting.
Success
Audit on successful 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 nontrusted 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 select this option, you must stop and restart the server for auditing to be enabled.
Failure
Audit on 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 nontrusted connections. Log records for these events appear in the Windows application log, the SQL Server error log, or both, depending on how you configure logging for your instance of SQL Server.
If you select this option, you must stop and restart the server to enable auditing.
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 nontrusted connections. Log records for these events appear in the Windows application log, the SQL Server error log, or both, depending on how you configure logging for your SQL Server.
If you select this option, you must stop and restart the server to enable auditing.
System account
Specify that the instance of SQL Server service account is the built-in local system administrator account.
This account
Specify that the SQL Server service account is a Microsoft Windows NT® 4.0 or Windows 2000 domain account. This field is only enabled if you are using a valid Windows NT 4.0 or Windows 2000 administrator account on the computer where the registered instance of SQL Server is running.
Password
Specify the password for the Windows NT 4.0 or Windows 2000 domain account. This field is only enabled if you are using a valid Windows NT 4.0 or Windows 2000 administrator account on the computer where the registered instance of SQL Server is running.