Results 1 to 8 of 8
  1. #1
    Join Date
    Oct 2003
    Posts
    20

    Unanswered: SQL Server 2000 password retry option

    In SQL Server 2000, can you enable an option to check password retries? For example if an SQL Server ID logs incorrectly 5 times, you disable the login account.

    Any help would be greatly appreciated. Thanks.

  2. #2
    Join Date
    Feb 2003
    Location
    India
    Posts
    216
    This is not directly supported in SQL Server. If this is needed for an application, ideally you should be having this logic in the application itself.

  3. #3
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    You should be using integrated security...
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  4. #4
    Join Date
    Apr 2006
    Posts
    33
    As blindman said - Integrated Security is the best way to go (although it's not always possible)

    With integrated security, you get the benefit of policys such as minimum password length, complexity requirements, password history, password age, lockout duration, lockout threshold...
    Integrated Security is more secure and it's better for end users - they only have 1 password to remember and authentication is seamless.
    David Wiseman
    MCSE, MCSA, MCDBA

    www.wisesoft.co.uk

  5. #5
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    You sure that signature link is big enough?
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  6. #6
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Quote Originally Posted by blindman
    You sure that signature link is big enough?
    Is there a limit?

    I have to admit, it certainly caught me off guard, but if it makes Wiseman82 happy I guess it's Ok by me.

    -PatP

  7. #7
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Quote Originally Posted by Pat Phelan
    Is there a limit?
    Maybe there should be. I'll bring it up in the moderator's forum.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  8. #8
    Join Date
    Apr 2006
    Posts
    33
    Sorry guys - didn't think 8kb was all that big...
    (Looks small enough on my 20" TFT and loads quick enough on bb )

    I've reduced the size of my sig to just over 4kb. - That's less tha twice the size of this smilie:
    David Wiseman
    MCSE, MCSA, MCDBA

    www.wisesoft.co.uk

Posting Permissions

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