SQL Account

Question

Post reply

SQL Account

Admingod

SSCertifiable

Points: 5997
More actions
February 3, 2020 at 4:27 pm

#3722663

Does ever SQL account get's locked due to failed login attempts or it will never get locked?

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

John Mitchell-245523 SSC Guru Points: 148809 More actions · Answer 1

Yes, it can do. Check the login's properties to see whether that's configured to happen.

John

Admingod SSCertifiable Points: 5997 More actions · Answer 2

You mean Enforce Password Policy and Pwd expiration? I enabled it and tested with failed attempts to see it cause any account locks? But the account lock did not happen?

Sue_H SSC Guru Points: 90860 More actions · Answer 3

It just enables the Windows local/domain policies when you select to enforce password policy. So you would want to check how it's setup in Windows for that server. Here is the documentation on that policy which indicates the same:

Password Policy

Sue

Admingod SSCertifiable Points: 5997 More actions · Answer 4

I am not looking for the domain accounts actually for the application accounts which is sql account only.

Sue_H SSC Guru Points: 90860 More actions · Answer 5

And that's exactly what the article is talking about. Read the second line: The password policy applies to a login that uses SQL Server authentication, and to a contained database user with password.

Sue

Admingod SSCertifiable Points: 5997 More actions · Answer 6

Thanks. I just tested if enforce password policy is checked then the account get's locked.