How to set up Windows Authentication Mode security (Enterprise Manager)

How to set up Windows Authentication Mode security (Enterprise Manager)

To set up Windows Authentication Mode security

1. Expand a server group.
   
   
2. Right-click a server, and then click Properties.
   
   
3. On the Security tab, under Authentication, click Windows only.
   
   
4. 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