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