使过期的SQL Server登录密码过期(无法更改密码) [英] Unexpiring an expired SQL Server Login password (Password cannot be changed)

问题描述

我有一个SQL Server登录名，该密码最近已过期.不幸的是，此密码是必需的，因为我们在开发机器上使用它进行应用程序测试.

I have a SQL server Login which password has recently expired. Unfortunately this password is necessary as we use it across Dev Machines for application testing purposes.

我无法更改此密码，但是我需要取消该密码.

I CAN'T change this password, but I need to unexpire it.

我得到的错误是: 错误28000用户用户名"的登录失败.原因:该帐户的密码已过期.

The error I am getting is : Error 28000 Login failed for user 'Username'. Reason: The password of the account has expired.

我正在使用SQL Server 2014. 没有选中强制密码策略"框.

I am using SQL Server 2014. The 'Enforce Password Policy' box is not ticked.

推荐答案

以系统管理员身份登录.将密码更改为其他密码.确保已禁用强制密码策略，然后将密码更改回原始密码.

Log in as a system administrator. Change the password to something else. Make sure enforce password policy is off and then change the password back to the original password.

这篇关于使过期的SQL Server登录密码过期(无法更改密码)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！