I have created a SQL user, but it force me to change to password. I go to the SQL Server Management Studio and untick the Enforce password policy. However it prompt the following message: The CHECK_POLICY and CHECK_EXPIRATION options cannot be turned OFF when MUST_CHANGE is ON (Microsoft SQL Server, Error: 15128) A SQL query can solve the problem ALTER LOGIN (Username here) WITH PASSWORD = '(Password here)'
Comments