login lockout- causes

  • What are the possible reason that a Sql login can lock out?

    Too many trails can cause to lock the login?

  • Yes.

    Are you recording login success/login failure in the engine? If so you can look in the ERRORLOG to see what did it. If you don't do this you should at least work out how to capture that information in rollover trace/extended event files, for your own security.

    It should be standard everywhere. You want to check and know every day when you've got a bunch of failed logins on a server, indicating an application has been misconfigured or an attack is in progress.

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

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