Tuesday, November 17, 2009

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

No comments: