security configurations report

[aruopna]

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

[rmiao]

The bad news is that you can't get most of them in sql2k.

[aruopna]

its ok if i can get the same for 2k5.
can u help me out?

thanx
arun

[rmiao]

Sql2k5 uses password policy in your ads, and logs failed login attemps in sql server log.

[aruopna]

thanx for the response,rmiao