[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

【推广】免费学中医，健康全家人

原文地址：https://www.cnblogs.com/lionetchen/p/9598519.html