Microsoft SQL Server, Error: 15128 ()

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

 

1. In the below step I am giving the same password, to fix “User Must Change Password” flag.

 

USE Master

GO

ALTER LOGIN [Login Name] WITH PASSWORD = 'Same Password'

GO

2. Turnoff the passowrd policy

 

ALTER LOGIN [Login Name] WITH

CHECK_POLICY = OFF,

CHECK_EXPIRATION = OFF;

Refer to:http://sqldbpool.com/2012/10/08/the-check_policy-and-check_expiration-options-cannot-be-turned-off-when-must_change-is-on-microsoft-sql-server-error-15128/