SQL Server Setup Help
How to set up Mixed Mode security (Enterprise Manager)
To set up Mixed Mode security
- Expand a server group.
- Right-click a server, and then click Properties.
- Click the Security tab.
- Under Authentication, click SQL Server and Windows.
- 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.
- None causes no auditing to be performed.