Sometime you may get the below error while executing some script:
Msg 15122, Level 16, State 1, Line 1The CHECK_EXPIRATION option cannot be used when CHECK_POLICY is OFF.
To solve this error, Turn On CHECK_POLICY in the script or remove CHECK_EXPIRATION from the script.
CREATE LOGIN [username] WITH PASSWORD=N'pa@Ssword' , CHECK_EXPIRATION=ON, CHECK_POLICY=ON
Msg 15122, Level 16, State 1, Line 1The CHECK_EXPIRATION option cannot be used when CHECK_POLICY is OFF.
To solve this error, Turn On CHECK_POLICY in the script or remove CHECK_EXPIRATION from the script.
CREATE LOGIN [username] WITH PASSWORD=N'pa@Ssword' , CHECK_EXPIRATION=ON, CHECK_POLICY=ON
No comments:
Post a Comment