-
security configurations report
Hi all,
I would like to retrive system report that provides the following security configurations for MS SQL
1. Minimum Password Length
2. Initial log-on uses a one time password
3. Password composition (e.g., alpha/numeric characters, not words in
dictionary)
4. Frequency of forced password changes (password expiration/aging)
5. The number of unsuccessful log-on attempts allowed before lockout
6. Ability of users to assign their own passwords
7. Number of passwords that must be used prior to using a password again
(password history)
8. Idle session time-out
9. Logging of unsuccessful login attempts
do i have to script it or is there any alternate option
thanx in advance
-
The bad news is that you can't get most of them in sql2k.
-
its ok if i can get the same for 2k5.
can u help me out?
thanx
arun
-
Sql2k5 uses password policy in your ads, and logs failed login attemps in sql server log.
-
thanx for the response,rmiao
Last edited by aruopna; 03-10-2008 at 01:30 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|