How to resolve: The password of the account must be changed

  • Please help I am just new to SQL 2005.

    I restored a backup copy of Sql 2000 DB to another PC which is running on SQL 2005 it all work fine and then I am having a login issue problem in this. What I do is I Delete the user at the Database level. Create the user at the Server Level and give my DB database permissions under the User Mapping section.

    Now after that I try to connect with my front end client or login page

    I get the below error message

    [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(UID)'. Reason: The password of the account must be changed

    Please advised what is wrong.

    Thank you so much.

  • When you created the login, did you specify the MUST_CHANGE option of CREATE LOGIN or, if you used Management Studio, did you leave the box checked that says, "User must change password at next login"? If you did, that's what's wrong. Change the password and you'll be back in business.

    Greg

  • Greg,

    Thank you for your tips...

    Yes I am using Management Studio, I delete the user and then I created again and then I leave all the boxes uncheck that says, "User must change password at next login...It works.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply