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'
- Blogger Comment
- Facebook Comment
Subscribe to:
Post Comments
(
Atom
)
12 commenti:
excellent.. thanks
This was great. thx - Chuck
Bala
Thanks a lot. It helps in time
Yes, but why?
Thanks a lot...:D
God bless you!! thanks a million!
Thank you sir... saved my butt
Thank you sir.. much appreciated
Worked! Thanks a lot.
Thanks, it worked
Saved my ass, thanks man - Frankie
Just what the doctor ordered.
Post a Comment