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/

Microsoft SQL Server, Error: 15128 (),古老的榕树,5-wow.com

郑重声明:本站内容如果来自互联网及其他传播媒体,其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享,并不代表本站赞同其观点和对其真实性负责,也不构成任何其他建议。