Re: ss2000 account lockout

Russell and Richard
Thank you


"Russell Fields" <russellfields@xxxxxxxxxx> wrote in message
news:exod5vcMIHA.1164@xxxxxxxxxxxxxxxxxxxxxxx
Also, according to Windows policy settings, when the lockout time period
elapses it will be automatically enabled.

RLF
"Uri Dimant" <urid@xxxxxxxxxxx> wrote in message
news:u0D31hcMIHA.5300@xxxxxxxxxxxxxxxxxxxxxxx
Hmm, I did not see that feature in real life yet. So, after a few
attempts Login will be locked automatically , how do you unlock it?


"Russell Fields" <russellfields@xxxxxxxxxx> wrote in message
news:eBM3iNcMIHA.3516@xxxxxxxxxxxxxxxxxxxxxxx
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
    ... 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: 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: Windows 98 getting stuck logging into a W2K3 domain.
    ... > workaround I've turned off Windows 98's ability in Client for MS ... > login stating that the domain can not be found, ... > Client for MS networks does the password validation. ...
    (microsoft.public.win2000.general)
  • RE: How to create a trusted connection
    ... You need to grant access for the Windows login by referring to the books ... is set to use Windows authentication to be able to do trusted connection. ... There are two modes of authentication in SQL Server: ...
    (microsoft.public.sqlserver.security)