Post reply

Failed Authentication Attempts

  • November 24, 2010 at 10:05 am

    #99433

    Is there a way in SQL Server 2000, to check within a given time frame if there have been any connection attempts that did not pass authentication?

    If there is, does the method work for 2005 as well, or is there a different way to check there?

    Thanks,

    Chris

  • November 24, 2010 at 12:43 pm

    #1255285

    Set the Audit level to "All" in SQL Server 2000 and "Both Failed and Successful logins" in SQL Server 2005. After restarting the services, you can see both failed and successful login attempts in the SQL Server Error Logs.

    SQL Server 2000 Screenshot

    SQL Server 2005 Screenshot

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply