Re: sql server 2005 account lockout
Jason (Jason@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
In 2005, I know I can inherit AD properties when using a sql account to
enforce password complexity rules, failed login lockout etc.
But if I do NOT want to inherit from AD, does SS2005 provide a way to lock
an account after x number of failed login attempts?
No. SQL Server relies on Windows policy for this, and does no work of
its own.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
Relevant Pages
- Re: Failure Audit Event ID: 18456 SQL Server Error
... you can always turn off failed login audit. ... "Anand Ganesh" wrote: ... The server has a public domain name. ... I am getting the following error in MS SQL SERVER 2005 Enterprise ...
(microsoft.public.sqlserver.connect) - Re: Failure Audit Event ID: 18456 SQL Server Error
... you can always turn off failed login audit. ... "Anand Ganesh" wrote: ... The server has a public domain name. ... I am getting the following error in MS SQL SERVER 2005 Enterprise ...
(microsoft.public.sqlserver.connect) - Re: failed login attempts
... but how do you setup profiler to return the PC name or IP ... I have used network monitor and setup a pattern match, which works, ... Microsoft SQL Server doesn't have built-in failed logins auditing ... >> support, including failed login attempts. ...
(microsoft.public.sqlserver.security) - Re: How trace logon failed
... You'd have to capture the host name (which may not ... >> SQL Server supports four kinds of Audit levels to record the user accesses ... All - successful and failed login attempts are both audited. ...
(microsoft.public.sqlserver.security) - Re: Tracing sql server user logins
... GroupName sysname NULL, ... FAQ from Neil & others at: http://www.sqlserverfaq.com ... SQL Server does not audit by ... >Failure causes only failed login attempts to be audited. ...
(microsoft.public.sqlserver.security) |
|
