Post reply

Auditing login failure using profiler

  • September 4, 2006 at 3:50 am

    #90362

    Hi,

     

    Is it possible to user profiler to audit login failure and to send the results to a table. Any one any ideas?

    Thanks

    Kindest Regards,

    BJ

  • September 4, 2006 at 9:25 am

    #658376

    Yes, setup a trace for those events and set the logging as a table. You can build a server side trace and have it run as a startup procedure.

  • September 5, 2006 at 3:59 am

    #658488

    Hello,

    For 'login failure' not much is being traced by the profiler if the user tries to use SQL Authentication... Anyone knows a way of tracking more information for that event? IP address of the computer or something tangible?

    Thanx,

    Hanslindgren!

     

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

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