I forgot to remove password expiration flag and I got the following error when I was removing it:
Msg 15128, Level 16, State 1, Line 1
The CHECK_POLICY and CHECK_EXPIRATION options cannot be turned OFF when MUST_CHANGE is ON.

The solution is to change the password using the following query and then remove the flag.
ALTER LOGIN MyLoginName WITH PASSWORD='mypasswordgoeshere'
Tags: , ,

About author

Vittorio Pavesi


  1. excellent.. thanks

  2. Anonymous
    5:07 PM

    This was great. thx - Chuck

  3. Balasubramaniyam.G
    1:52 PM


    Thanks a lot. It helps in time

  4. Soonam
    6:26 PM

    Thanks a lot...:D

  5. Anonymous
    4:39 AM

    God bless you!! thanks a million!

  6. Anonymous
    11:53 PM

    Thank you sir... saved my butt

  7. Anonymous
    11:55 PM

    Thank you sir.. much appreciated

  8. Anonymous
    5:33 PM

    Worked! Thanks a lot.

  9. Thanks, it worked

  10. Anonymous
    2:59 PM

    Saved my ass, thanks man - Frankie

  11. Just what the doctor ordered.

Post a Comment