It's very annoying to create a new SQL user and forget to clear the "User must change password at next login" checkbox.
This will result in an error message:
Login failed for user 'login_name'. Reason: The password of the account must be changed.
If you try to clear the message, you get:
The CHECK_POLICY and CHECK_EXPIRATION options cannot be turned OFF when MUST_CHANGE is ON. (Microsoft SQL Server, Error: 15128)
One solution is to delete the user and create again, and clear the checkbox. Another solution I found on Experts Exchange:
ALTER LOGIN UserLogin WITH PASSWORD = 'NewPassword' UNLOCK
Then you can uncheck 'Enforce password policy' and 'Enforce password expiration' or just run the following two sql commands:
ALTER LOGIN UserLogin WITH CHECK_EXPIRATION = OFF
ALTER LOGIN UserLogin WITH CHECK_POLICY = OFF
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23063893.html
