A user lost the password to a database login and when i changed the password I got the following message in the face.
Msg 15128, Level 16, State 1, Line 1The 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='yourpassword'
Prenumerera på:
Kommentarer till inlägget (Atom)
0 kommentarer:
Skicka en kommentar