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

Error Message:
Msg 15128, Level 16, State 1, Line 2
The CHECK_POLICY and CHECK_EXPIRATION options cannot be turned OFF when MUST_CHANGE is ON.

Severity level:
16.

Description:
This error message appears when you try to deactivate the CHECK_EXPIRATION and the CHECK_POLICY option in a CREATE LOGIN statement, while the MUST_CHANGE option is activated.

Consequences:
The T-SQL statement can be parsed, but causes the error at runtime.

Resolution:
Errors of the Severity Level 16 are generated by the user and can be fixed by the SQL Server user. The statement cannot be executed this way. When you use the MUST_CHANGE option, should CHECK_POLICY be activated for CHECK_EXPIRATION to make sense at.

Versions:
This error message was introduced with SQL Server 2005.

Example(s):
USE Master;
CREATE LOGIN MyLogin
 WITH PASSWORD = ‘ABC’
 MUST_CHANGE,
 CHECK_POLICY = OFF,
 CHECK_EXPIRATION = OFF;
GO

Remarks:
In the above example we try to activate the MUST_CHANGE option, even though both CHECK_POLICY as well as CHECK_EXPIRATION are deactivated. This raises the error.




Related Articles :

  • No Related Articles Found

2 Responses to “The CHECK_POLICY and CHECK_EXPIRATION options cannot be turned OFF when MUST_CHANGE is ON.”

  1. Change the password to same password first and save.
    Then open the properties again and remove the check from Expire password option, you should be able to do it.

    OR you can execute below sql to change the options:

    USE Master
    GO
    ALTER LOGIN login_name WITH PASSWORD = ‘sameoldpassword’
    GO
    ALTER LOGIN login_name WITH
    CHECK_POLICY = OFF,
    CHECK_EXPIRATION = OFF

    Thanks
    Praveen

Trackbacks/Pingbacks

  1. SQL Server Performance - May 22, 2011

    [...] [...]

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |