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

To set up Windows NT Authentication Mode security

1. Expand a server group.
2. Right-click a server; then click Properties.
3. Click the Security tab.
4. Select Windows NT only.
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