Login attempts

are there option for administrator to set the number of
attempts of password login into the sql server?
thanksHi,
In SQL Server authentication you can't set the password attempts, because
there is no password policies inside sql server.
You can set password attempts policy for Windows based logins.
How to set
1. Control panel-- Adminstraive tools
2. Select Local security settings
3. Select account lockout policy and select Account lockout threshold.
4. DEfine the value for that policy and click ok.
Thanks
Hari
MCDBA
"NG" <angiecmf@.hotmail.com> wrote in message
news:11bba01c410ae$8a7e6670$a401280a@.phx
.gbl...
> are there option for administrator to set the number of
> attempts of password login into the sql server?
> thanks