elementary business solutions

I tried to remove the check_policy and check_expiration from a user and got following error in MS SQL Server:

The CHECK_POLICY and CHECK_EXPIRATION options cannot be turned OFF when MUST_CHANGE is ON.

I forgot to remove the must change password flag when I created the user. A simple SQL query to change the users password solved the problem:

ALTER LOGIN %USERNAME% WITH PASSWORD='%PASSWORD%'