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, and then click Properties.
   
   
3. Click the Security tab.
   
   
4. Under Authentication, click SQL Server and Windows.
   
   
5. Under Audit level, select the level at 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 Modes