Re: ss2000 account lockout

Same as in AD. Either wait for the lockout duration or have an admin unlock
the account for you. Once the AD account is unlocked you can authenticate to
SQL Server.

--
Richard Mueller
Microsoft MVP Scripting and ADSI
Hilltop Lab - http://www.rlmueller.net
--

"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: limit the maximum time allowed for a log-in attempt
    ... to create a delay between each consecutive login attempt ... >> is some delay between consecutive windows logon attempt. ... >long an account is locked out for; ... >lockout threshold figure. ...
    (microsoft.public.security)
  • Re: Administrator Account Locked Out
    ... Support- Dell- vendor's account for help and support ... Are there kids in the house that have physical access to your computer? ... You may have to wait up to 30 minutes to wait for the lockout to expire. ... one is trying to login while you are waiting for the lockout to expire. ...
    (microsoft.public.windowsxp.security_admin)
  • Re: account locked after restarting the machine
    ... > professional machines are connected.and logon script also ... > trying to login in morning it shows account lockout error ... when i unlock the account it works smoothly. ...
    (microsoft.public.win2000.networking)
  • Re: problem with maxInvalidPasswordAttempts
    ... When a user tries to login to an account more than "maxInvalidPasswordAttempts" times, ... You must unlock the account before it can be used again. ... The password is "hashed" and sent by mail to the member. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: how to access locked SA login to which password is also not known
    ... I have a server running on a unix box to which the sa login has been ... If you have a login with sso privs you can unlock the account with sp_locklogin and reset the password with sp_password, ...
    (comp.databases.sybase)
Loading