RE: sql server 2005 account lockout

Hi Jason,
SQL Server 2005 does not provide built-in function for locking an account
after specific times of login failure; however in SQL Server 2005 you can
create a logon trigger to implement your needs by yourself.
You may refer to:
Logon Triggers
http://technet.microsoft.com/en-us/library/bb326598.aspx

Hope this helps. If you have any other questions or concerns, please feel
free to let me know. Have a nice day!

Best regards,
Charles Wang
Microsoft Online Community Support
=====================================================
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================






.

Relevant Pages

  • Re: Security for Visual Studio.Net
    ... Point taken about using a less privileged account for SQL Server access. ... > I assume you have your connection strings mixed up in this post, ... > Windows login failure), and the second connection string is attempting to ...
    (microsoft.public.sqlserver.security)
  • Re: Security for Visual Studio.Net
    ... Point taken about using a less privileged account for SQL Server access. ... > I assume you have your connection strings mixed up in this post, ... > Windows login failure), and the second connection string is attempting to ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Cant Start Local Instance
    ... I am confused regarding the login settings. ... When I installed the SQL Server ... and then I have the same password set for the "sa" account, ... >>> If you get a login failure message, saying tht the password is not ...
    (microsoft.public.sqlserver.setup)
  • Re: Cant start SS7
    ... Login failure? ... password of the account used by SQL Server service is changed. ... Vyas, MVP ...
    (microsoft.public.sqlserver.setup)
  • Re: Error 15401 using sp_grantlogin (not addressed by current KB articles)
    ... Restarting Windows 2000 resolved the problem for this particular account, ... confused when it sees a duplicate SID. ... > One way to get SQL Server to agree with the renamed NT ... > Preview (to ensure the script was created), ...
    (microsoft.public.sqlserver.security)