SQL Server 2005: MUST_CHANGE is ON
I have created a SQL user, but it force me to change to password. I go to the SQL Server Management Studio and untick the Enforce password policy. However it prompt the following message:
The CHECK_POLICY and CHECK_EXPIRATION options cannot be turned OFF when MUST_CHANGE is ON (Microsoft SQL Server, Error: 15128)A SQL query can solve the problem
ALTER LOGIN (Username here) WITH PASSWORD = '(Password here)'