The CHECK_POLICY and CHECK_EXPIRATION options cannot be turned OFF when MUST_CHANGE is ON. (Microsoft SQL Server，错误: 15128)
记录下
The CHECK_POLICY and CHECK_EXPIRATION options cannot be turned OFF when MUST_CHANGE is ON. (Microsoft SQL Server, Error: 15128)
Problem: Recently one of my user reported the issue that, He is getting password change message while login to SQL Server. But he does not want to change the password as he has already configured at the many places. While turning off the Password Expiration message, I got the below error.
The CHECK_POLICY and CHECK_EXPIRATION options cannot be turned OFF when MUST_CHANGE is ON. (Microsoft SQL Server, Error: 15128)
Solution:
To fix the issue you MUST have to change the password first without changing in password policy options. The good thing it that you can change the password to be the same as the existing one. -:)
But still you have to change the password -:) what a logic!!! You can do it from SSMS GUI as well, but I always prefer to use the scripts as it is giving me flexibility of customization.
That was the another reason I am in the support of open source software you have flexibility to add your ideas. Let’s go to fix the issue.
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
Now let’s turn off the passowrd policy.
ALTER LOGIN [Login Name] WITH
CHECK_POLICY = OFF,
CHECK_EXPIRATION = OFF;
最新文章
- Python入门5
- solr的suggest模块
- C#实现WebService服务 项目完整总结
- 深入了解css的行高Line Height属性
- 使用Cloudera部署，管理Hadoop集群
- Linux初识（转）
- [转]如何下载tizen源码(图文教程)?
- android application类的用法
- git 彩色显示当前branch
- CSS小注意（初级）
- 蜗牛—JSP学习之JavaBean初识
- effective C++ 读后笔记
- css中的字体样式及元素样式
- HDU 4333 Revolving Digits 扩张KMP
- 使用Visifire+ArcGIS API for Silverlight实现Graphic信息的动态图表显示
- [转载] 详述三种现代JVM语言--Groovy，Scala和Clojure
- 小白学习Python之路---re模块学习和挑战练习
- C# 堆栈（Stack）和队列（Queue）
- web@css样式进阶--图形字体、动画、显隐....
- Runtime之成员变量&属性&关联对象