How to set up Mixed Mode security (Enterprise Manager)

To set up Mixed Mode Security

1. Expand a server group.
2. Right-click a server; then click Properties.
3. Click the Security tab.
4. Select SQL Server and Windows NT.
5. In Audit level, select the level to which user accesses to Microsoft® SQL Server™ are recorded in the SQL Server error log:
   • None causes no auditing to be performed.
   • Success causes only successful login attempts to be audited.
   • Failure causes only failed login attempts to be audited.
   • All causes successful and failed login attempts to be audited.

See Also

Authentication