“The CHECK_POLICY and CHECK_EXPIRATION options cannot be turned OFF when MUST_CHANGE is ON.”
When logging in to SQL Server Instance with a Login, you can receive a message that your password has expired and should be changed. If you receive such a warning message, then this means that the “CHECK_EXPIRATION” property of the corresponding Login is enabled.
If your password expires, the password must be updated. If you want to cancel the “CHECK_EXPIRATION” feature from the Login ‘s properties without updating the password, you will see the above error message.
First of all, the password of the corresponding Login must be changed. You can do this using the SSMS interface or T-SQL commands.
– Open SSMS -> Security -> Logins, then right-click on the corresponding Login and open the Properties window.
– Change the password of Login and uncheck “User must change password at next login”. Click ‘OK’ to close the window.
– If you do not want the Password Policy and Password Expiration rule to be reapplied for this Login, you can re-open the Login’s Properties window and uncheck “Enforce password expiration” and “Enforce password policy”. We could not do this before because the previous step must be completed first.
Aşağıdaki komutu kullanarak ilgili Login’ in şifresini değiştirin.
ALTER LOGIN [Login_Name] WITH PASSWORD=N'xxx'
If you want, you can then close the CHECK_EXPIRATION and CHECK_POLICY properties by using the following command.
ALTER LOGIN [Login_Name] WITH DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF