SQL Server Properties (Security Tab)

SQL Server Enterprise Manager Help

SQL Server Enterprise Manager Help

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.

See Also

Setting Configuration Options