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...
SQL Server uses the same password policies as the domain.
You can query it
LOGINPROPERTY (Transact-SQL) - SQL Server | Microsoft Learn
=> DaysUntilExpiration
That's not my question. Neither am I on a domain. The SQL logins in question are on an Azure Managed Instance and in this case, Entra ID is not an option.
My end users can't run that query. I need to know if they will have a chance to reset their own passwords should they expire.
