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 you try to use a CHECK_EXPIRATION = ON option in a CREATE LOGIN statement while die CHECK_POLICY option is deactivated.
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. CHECK_POLICY must be activated for CHECK_EXPIRATION to make sense.
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 CHECK_POLICY option is set to FALSE, while CHECK_EXPIRATION is set to TRUE. This raises the error.