MUST_CHANGE is ON

I tried to remove the check_policy and check_expiration from a user and got following error in MS SQL Server:

I forgot to remove the must change password flag when I created the user. A simple SQL query to change the users password solved the problem:

ALTER LOGIN %USERNAME% WITH PASSWORD='%PASSWORD%'

admin on May 11th 2008 in IT, MSSQL

No Comments »

Trackback URI | Comments RSS

Leave a Reply

*




Check out new movies online website. Download and buy movies now.
1