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

When a user account is created on SQLServer on 2005 with user account set to “Enforce password policy” and “Enforce password expiration”, once set this policy and expiration can’t be changed using.

ALTER LOGIN test WITH CHECK_EXPIRATION = OFF;
Or
ALTER LOGIN test WITH CHECK_POLICY = OFF;

SQLserver will return the following message
Msg 15128, Level 16, State 1, Line 1
The CHECK_POLICY and CHECK_EXPIRATION options cannot be turned OFF when MUST_CHANGE is ON.

To fix this issue which will keep the password the same and it will turn off check policy and expiration.
ALTER LOGIN test WITH PASSWORD = ”
GO
ALTER LOGIN test WITH
CHECK_POLICY = OFF,
CHECK_EXPIRATION = OFF;

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.