SQL Server Error: The CHECK_POLICY and CHECK_EXPIRATION options cannot be turned OFF when MUST_CHANGE is ON.
/* The solution is: */
USE Master
GO
ALTER LOGIN MyLogin WITH PASSWORD = 'mypassword'
GO
ALTER LOGIN MyLogin WITH
CHECK_POLICY = OFF,
CHECK_EXPIRATION = OFF;
No Comments
You must log on to comment.