Re: ss2000 account lockout

Uri,

No, I was talking about the SQL Server adopting Windows policy rules for
automatic lockout of a login after too many failed login attempts. SQL
Server 2005 running on Windows 2003 will adopt Windows logins policies as
the definition for password complexity, login lockout, etc.

Of course, the logon trigger is also new with 2005.

Russell

"Uri Dimant" <urid@xxxxxxxxxxx> wrote in message
news:O$M26kYMIHA.4480@xxxxxxxxxxxxxxxxxxxxxxx
Russell
Jason, Correct. That feature was added in SQL Server 2005.

Do you mean to create for logon trigger?

"Russell Fields" <russellfields@xxxxxxxxxx> wrote in message
news:%232sigHRMIHA.5208@xxxxxxxxxxxxxxxxxxxxxxx
Jason, Correct. That feature was added in SQL Server 2005. - RLF

"Jason" <Jason@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:42592E25-20AC-4D46-876D-76B5531C8BD5@xxxxxxxxxxxxxxxx
Google wasn't cooperating today.
I'm 95% sure the answer is no, maybe I'm just in denial. SS2000 does
not
provide the ability to lock a user account after x number of failed
logins,
correct? I see that I can turn auditing on in the security tab though,
but
that just adds an entry to the windows application log.







.

Relevant Pages

  • Re: ss2000 account lockout
    ... I was talking about the SQL Server adopting Windows policy rules for ... automatic lockout of a login after too many failed login attempts. ... Server 2005 running on Windows 2003 will adopt Windows logins policies as ...
    (microsoft.public.sqlserver.security)
  • Re: ss2000 account lockout
    ... automatic lockout of a login after too many failed login attempts. ... Server 2005 running on Windows 2003 will adopt Windows logins policies as ... the logon trigger is also new with 2005. ...
    (microsoft.public.sqlserver.security)
  • Re: ss2000 account lockout
    ... automatic lockout of a login after too many failed login attempts. ... Server 2005 running on Windows 2003 will adopt Windows logins policies ... the logon trigger is also new with 2005. ...
    (microsoft.public.sqlserver.security)
  • RE: Password never set - locked out of Windows XP Home
    ... Ran fixboot last night, and although the system said it had fixed the boot ... I am still stuck in the redundant loop of getting to a pop-up login ... only to not have it shutdown but instead pop back up with the same login box. ... my Windows XP Home system worked great. ...
    (microsoft.public.windowsxp.accessibility)
  • Re: sp_revoke login is not working as expected.
    ... EXEC xp_logininfo 'MyDomain\SomeUserAccount','members' ... Try specifying a group member rather than the group. ... This should list the Windows groups the user can connect with. ... connect with the non-existing login. ...
    (microsoft.public.sqlserver.security)