The CHECK_POLICY and CHECK_EXPIRATION options cannot be turned OFF when MUST_CHANGE is ON.

You have created a Login in SQL Server of type SQL Server Authentication. You did not wanted to Enforce Policy Option opted, but you forgot to uncheck the option and created the login.

Later you realize that you did not wanted the Enforce Policy option. You go to Management Studio and try to uncheck the Enforce Policy option and you will end up with below error.

"The CHECK_POLICY and CHECK_EXPIRATION options cannot be turned OFF when MUST_CHANGE is ON."

This cannot be resolved using GUI by any way.

To Resolve this, you can run the below query which will remove Password Policy on the Login you have created.

USE Master
GO
ALTER LOGIN [testaccess] WITH PASSWORD = 'oldpasswordwhichhadprovided'
GO
ALTER LOGIN [testaccess] WITH
CHECK_POLICY = OFF,
CHECK_EXPIRATION = OFF;