Server Properties (Security Page)
Applies To: SQL Server 2016
Use this page to view or modify your server security options.
Windows Authentication mode
Uses Windows Authentication to validate attempted connections. If the sa password is blank when the security mode is being changed, the user is prompted to enter an sa password.
SQL Server and Windows Authentication mode
Uses mixed mode authentication to verify attempted connections, for backward compatibility with earlier versions of SQL Server. If the sa password is blank when the security mode is being changed, the user is prompted to enter an sa password.
Turns off login auditing.
Failed logins only
Audits unsuccessful logins only.
Successful logins only
Audits successful logins only.
Both failed and successful logins
Audits all login attempts.
Enable server proxy account
Enables an account for use by xp_cmdshell. Proxy accounts allow for the impersonation of logins, server roles, and database roles when an operating system command is being executed.
Specify the proxy account used.
Specify the password for the proxy account.
Enable C2 audit tracing
Audits all attempts to access statements and objects and records them to a file in the \MSSQL\Data directory for default instances of SQL Server, or the \MSSQL$instancename\Data directory for named instances of SQL Server. For more information, see c2 audit mode Server Configuration Option.
Cross database ownership chaining
Select to allow the database to be the source or target of a cross-database ownership chain. For more information, see cross db ownership chaining Server Configuration Option.