SQL Server 2005: MUST_CHANGE is ON

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)'


Popular posts from this blog

Post packing slip of sales order in X++

Ctrl, Alt or Shift button of Type Cover 2 are getting stuck