Msg 15122, Level 16, State 1, Line 2
The CHECK_EXPIRATION option cannot be used when CHECK_POLICY is OFF.
This error message appears when attempting to use the CHEKC_EXPIRATION = ON Option in a CREATE LOGIN statement, while the CHECK_POLICY Option is set to OFF.
The T-SQL statement can be parsed, but causes the error at runtime.
Error of the Severity Level 16 are generated by the user and can be fixed by the SQL Server user. The statement can not be executed this way. The CHECK_POLICY must be set to ON for the CHECK_EXPIRATION option to make sense at all.
This error message was introduced with SQL Server 2005
CREATE LOGIN MyLogin
WITH PASSWORD = ‘ABC’,
CHECK_POLICY = OFF,
CHECK_EXPIRATION = ON;
In the above example we try to create a login for which the CHEKC_POLICY option is set to OFF, while CHECK_EXPIRATION is set to ON. This raises the error.