Post reply

Revoke Permissions on Failed Logins

  • April 26, 2005 at 6:43 am

    #85961

    Hi,

    I am starting to design a system in VB.Net using a SQL Server database. I hope to use Windows Authentication. Basically what I want to do is lock users out automatically after X number of consecutive failed logins. What is the best way to go about this?

    Thanks in Advance.

    Declan.

  • April 27, 2005 at 3:14 am

    #555134

    forgive me if I'm on the wrong tack here.  but with windows authentication, there is no inputting of the password into SQL....so there is no failed SQL logon (for password reasons anyway).

    There may be a failed logon, because the windows logon is not registered in SQL....but if that's the case then there is no permissions to deny anyway...what's the point the user can't signon in the 1st place?

    I think you are setting some hurdles that may be too high.

  • April 27, 2005 at 4:41 am

    #555146

    Fair point! Thanks for the reply.

  • April 27, 2005 at 7:33 am

    #555207

    SQL Server 2005 is able to handle your request. It is not released yet.

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

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