Creating, or recreating, a SQL user account and I forgot to untick the “must change password” option. Damn.
If you try to disable the password policy options, you get a message saying “The CHECK_POLICY and CHECK_EXPIRATION options cannot be turned OFF when MUST_CHANGE is ON. (Microsoft SQL Server, Error: 15128)”
Rather than recreate the account, you can disable the options using a script
Source: http://www.webofwood.com/2009/01/29/fix-a-sql-server-login-which-has-must_change-set-to-on/
USE Master GO ALTER LOGIN [username] WITH PASSWORD = 'samepassword' GO ALTER LOGIN [username] WITH CHECK_POLICY = OFF, CHECK_EXPIRATION = OFF;