When a user account is created on SQLServer on 2005 with user account set to "Enforce password policy" and "Enforce password expiration", once set this policy and expiration can't be changed using. ALTER LOGIN test WITH CHECK_EXPIRATION = OFF; Or ALTER LOGIN test WITH CHECK_POLICY = OFF; SQLserver will return the following message Msg 15128, … Continue reading The CHECK_POLICY and CHECK_EXPIRATION options cannot be turned OFF when MUST_CHANGE is ON →