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
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