Authentication locking mechanism on SQL 2000 CE

Dear Sir/Mam,
Kindly let me know that whether it is possible to set
authentication locking mechanism that will provide the
feature for disabling user accounts after 2 unsuccessful
login attempts and automatic password expiry on SQL 2000
clients.
Regards
Vetrivel.S
There is no such feature on SQL Server 2000. SQL 2005 will provide features
in those areas but it is a little ways off yet. If you need that capability
I suggest you use the Windows security mode and not the SQL Server security.
That way you can take advantage of all these features built in to Windows
security already.
Andrew J. Kelly SQL MVP
"Vetrivel" <vetkar123@.rediffmail.com> wrote in message
news:4a7a01c4739a$7f79c0e0$a301280a@.phx.gbl...
> Dear Sir/Mam,
> Kindly let me know that whether it is possible to set
> authentication locking mechanism that will provide the
> feature for disabling user accounts after 2 unsuccessful
> login attempts and automatic password expiry on SQL 2000
> clients.
> Regards
> Vetrivel.S