Remove MUST_CHANGE_PASSWORD from user

If you accidentially forget to remove the “Must change password” and the “Enforce password policy” when you create a user, you need to change the password for the user.

This is a must before you can remove the Enforce password policy.

Below script will change the password and remove the policy. You can use the same password as before.

USE Master
GO
ALTER LOGIN test_must_change WITH PASSWORD = 'samepassword'
GO
ALTER LOGIN test_must_change WITH
      CHECK_POLICY = OFF,
      CHECK_EXPIRATION = OFF;

Information found here: http://www.webofwood.com/2009/01/29/fix-a-sql-server-login-which-has-must_change-set-to-on/