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
USE Master GO ALTER LOGIN [username] WITH PASSWORD = 'samepassword' GO ALTER LOGIN [username] WITH CHECK_POLICY = OFF, CHECK_EXPIRATION = OFF;