Re: SQL 2000 Lockout?

zz12,

With SQL Server 2000, there is nothing native to do this. If someone else
has code to do this I don't remember who they are any more.

If you server is set to Audit Failed Logins, these entries will go into your
event logs and you could write some code to periodically scan the event log.
(Not the same as automatic lockout, of course, but it is something.)

RLF


"zz12" <IDontLikeSpam@xxxxxxxxxxx> wrote in message
news:%23QDyj%23vpIHA.3616@xxxxxxxxxxxxxxxxxxxxxxx
Hello, would anyone know if there's a way to lockout mainly a SQL (or
Windows) login for SQL Server 2000? Was wondering if there was like a
stored procedure out there that could be added to the Master db running as
a system process that checks for like 3 failed login attempts or something
along those lines.

Thanks in advance.



.

Relevant Pages

  • RE: SQL logins logged where
    ... Enable SQL Server auditing for successfull and failed logins. ... Right click on the server in Enterprise Manager, Properties, Security Tab, ... Select audit for successfull & failed logins. ...
    (microsoft.public.sqlserver.security)
  • RE: intrusion detection, etc. for sql server
    ... The only thing that SQL has is auditing for successfull and failed logins. ... To protect your SQL Server and/or restrict access to it, ...
    (microsoft.public.sqlserver.security)
  • ISA server 2004 logging to SQL 2005 EXpress
    ... Since I upgraded the MSDE 2000 tot SQL Server 2005 Express, my event logs fill up with event 17137 "Starting up database". ... but ISA creates a new table each day which has again Autoclose=true. ... I don't want the SQL server to close/reopen the logging table thousands of times a day! ...
    (microsoft.public.isa)
  • Re: Cluster Failure Server Reboots
    ... Event logs are your friend. ... I support the Professional Association for SQL Server ... > Active/Active cluster with SQL Server 2000 Enterprise ...
    (microsoft.public.sqlserver.clustering)
  • Re: Cant start SQL 2000 after MS Update
    ... check the event logs and your SQL Server ... error log (the errorlog file in the SQL Server installation path \Log ... >>If you continue to have problems connecting, ...
    (microsoft.public.sqlserver.security)