Export (0) Print
Expand All
Expand Minimize

How to set up Mixed Mode security (Enterprise Manager)

SQL Server 2000

How to set up Mixed Mode security (Enterprise Manager)

  New Information - SQL Server 2000 SP3.

Security Note  When possible, use Windows Authentication.

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.

    Security Note  Microsoft recommends auditing, at minimum, failed login attempts. Auditing failed login attempts helps determine if unauthorized users are attempting to access the system.

See Also

Authentication Modes

Show:
© 2014 Microsoft