none
SQL 2005- Report to display detail of failed login attempts.

    Question

  • How do you display the detail of failed login attempts within sql 2005.

    Newbe to Sql 2005.

    Thanks,

    Jan
    Friday, September 25, 2009 1:56 PM

Answers

  • See this article on configuring, and extracting the entries from the errorlog. Be aware that sp_readerrorlog is undocumented, so *could* be dropped in a future version of SQL Server. It's used a lot though.

    http://www.mssqltips.com/tip.asp?tip=1735

    HTH

    Ewan

    If you have found this post helpful, please click the 'Vote as Helpful' link (the green triangle and number on the top-left).

    If this post answers your question, click the 'Mark As Answered' link below. It helps others who experience the same issue in future to find the solution.
    • Marked as answer by jan_9999 Friday, September 25, 2009 4:22 PM
    Friday, September 25, 2009 2:40 PM

All replies

  • Hi Jan

    In SSMS, right-click on the server. In the Security Tab, you enable Failed Logins.

    Failed login attempts then get logged to the SQL Server Error Log.

    HTH

    Ewan


    If you have found this post helpful, please click the 'Vote as Helpful' link (the green triangle and number on the top-left).

    If this post answers your question, click the 'Mark As Answered' link below. It helps others who experience the same issue in future to find the solution.
    Friday, September 25, 2009 2:30 PM
  • See this article on configuring, and extracting the entries from the errorlog. Be aware that sp_readerrorlog is undocumented, so *could* be dropped in a future version of SQL Server. It's used a lot though.

    http://www.mssqltips.com/tip.asp?tip=1735

    HTH

    Ewan

    If you have found this post helpful, please click the 'Vote as Helpful' link (the green triangle and number on the top-left).

    If this post answers your question, click the 'Mark As Answered' link below. It helps others who experience the same issue in future to find the solution.
    • Marked as answer by jan_9999 Friday, September 25, 2009 4:22 PM
    Friday, September 25, 2009 2:40 PM
  • Ewan,

    Thanks this was very useful.!!!!! Great sp.

    Jan

    Friday, September 25, 2009 4:23 PM