Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2014
    Posts
    3

    Unanswered: Db admin user locking

    How to lock DB admin user on unsuccessful 3 attempts?

  2. #2
    Join Date
    Feb 2012
    Posts
    133
    There is a server wide settings for configuring max failed logins

    sp_configure 'maximum failed logins'

    or

    you can try modifying per individual login for maximum failed attempts, in your case you can try

    sp_modifylogin <user_name>, "max failed logins" , "3"

  3. #3
    Join Date
    Oct 2014
    Posts
    3
    Is it not possible that i create login policy with max login failed attempts = 3. But this is not locking DBA but locking other DB User

  4. #4
    Join Date
    Feb 2012
    Posts
    133
    you can create login trigger for those login accounts and bind the trigger on individual users on database

Posting Permissions

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