MUST_CHANGE=Off

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'
Share on Google Plus

About Vittorio Pavesi

    Blogger Comment
    Facebook Comment

12 comments:

don said...

excellent.. thanks

Anonymous said...

This was great. thx - Chuck

Balasubramaniyam.G said...

Bala

Thanks a lot. It helps in time

Jerry Nixon said...

Yes, but why?

Soonam said...

Thanks a lot...:D

Anonymous said...

God bless you!! thanks a million!

Anonymous said...

Thank you sir... saved my butt

Anonymous said...

Thank you sir.. much appreciated

Anonymous said...

Worked! Thanks a lot.

harism said...

Thanks, it worked

Anonymous said...

Saved my ass, thanks man - Frankie

Webmasterino said...

Just what the doctor ordered.