When MUST_CHANGE is ON, the CHECK_POLICY and CHECK_EXPIRATION options cannot be set to OFF or checkchange

When MUST_CHANGE is ON, the CHECK_POLICY and CHECK_EXPIRATION options cannot be set to OFF or checkchange

In fact, in the following situations, 2005 and 2008 are prone to this problem.

When creating an account in SQL Server 2008, select "Enforce Password Policy", for example:

After the creation, I do not want to use the policy. I canceled "force password policy implementation", for example:

Click OK. An error occurs, such:

The details are as follows:

Title: Microsoft SQL Server Management Studio
------------------------------

Failed to log on to "test1. (Microsoft. SqlServer. Smo)

Click: http://go.microsoft.com/fwlink? For help information? ProdName = Microsoft + SQL + Server & ProdVer = 9.00.3042.00 & EvtSrc = Microsoft. SqlServer. Management. Smo. ExceptionTemplates. FailedOperationExceptionText & EvtID = change + Login & LinkId = 20476

------------------------------
Other information:

An exception occurred when executing a Transact-SQL statement or batch processing. (Microsoft. SqlServer. ConnectionInfo)

------------------------------

When MUST_CHANGE is ON, the CHECK_POLICY and CHECK_EXPIRATION options cannot be set to OFF ). (Microsoft SQL Server, error: 15128)

Click: http://go.microsoft.com/fwlink? For help information? ProdName = Microsoft + SQL + Server & ProdVer = 09.00.3042 & EvtSrc = MSSQLServer & EvtID = 15128 & LinkId = 20476

========================================================== ====================================

I have been studying for half a day and I have to use it

Alter login Name with password = 'new password ';

Modify the password of this account first!

This is to change the login password as a sa. I feel that this option allows the login user to change the password after login. After I try it, I cannot log on at all, that is, I am prompted to change the password.

The Windows Server account can log on and change the password. How can I set the password in SQL Server?

In fact, a simple method is:

Delete and recreate a user"