Msg 15128, Level 16, State 1, Line 2
The CHECK_POLICY and CHECK_EXPIRATION options cannot be turned OFF when MUST_CHANGE is ON.
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.
The T-SQL statement can be parsed, but causes the error at runtime.
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.
This error message was introduced with SQL Server 2005.
CREATE LOGIN MyLogin
WITH PASSWORD = ‘ABC’
CHECK_POLICY = OFF,
CHECK_EXPIRATION = OFF;
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.