[SQL SERVER] The CHECK_POLICY and CHECK_EXPIRATION options cannot be turned OFF when MUST_CHANGE is ON. (Microsoft SQL Server, Error: 15128)

The CHECK_POLICY and CHECK_EXPIRATION options cannot be turned OFF when MUST_CHANGE is ON. (Microsoft SQL Server, Error: 15128)

 

ALTER LOGIN [LoginName]
WITH PASSWORD = 'PWD'

ALTER LOGIN [LoginName] WITH
CHECK_POLICY = OFF,
CHECK_EXPIRATION = OFF