Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2002
    Posts
    9

    Unanswered: Recording failed logins

    There is a requirement on two of the systems I am looking after to record any failed attempts to connect to SQL server. The SQL server version is 7. Is it possible to record and extract failed SQL server logins in SQL Server 7 and if so how is it done?

    Thanks.

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    In EM - right click your server and click on properties. Click on the security tab and select the appropriate audit level (in your case failure or all).

  3. #3
    Join Date
    Dec 2002
    Posts
    9
    Thank you.

  4. #4
    Join Date
    Feb 2002
    Posts
    2,232
    You are welcome and good luck.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •