Forum Discussion
Password Expiration Behavior
If I set check_expiration = on for a SQL authenticated login, will the user get prompted to change their password either: after it expires just before it expires not at all I can't force a logi...
All I'm able to find is this text:
When SQL Server enforces password expiration policy, users are reminded to change old passwords, and accounts that have expired passwords are disabled.
Password Policy - SQL Server | Microsoft Learn
It doesn't say anything about at which point users start getting reminders.
From what I can see, once the password has expired, they need assistance from someone with sufficient privileges to reset the password and enable the account again.