Reset User Password

Hi Everyone,

In Acumatica all passwords are stored as a Hash, so even if you get database, you are not able to login with user password.
But in case of trouble you can reset it to new one directly in the database. Just execute this query against the sql:

UPDATE Users SET Password = '123', LockedOutDate =null WHERE Username = 'admin'

Don’t worry about clear text password – Acumatica will automatically calculate new hash on first login operation.
LockedOutDate is field where system stores last unsuccessful login attempt date-time. So if your user is locked out you can use this statement to unlock it.

Thank you!

5 Replies to “Reset User Password”

    1. Hi Carlos, add CompanyID = to the where statement, like here:
      UPDATE Users SET Password = ‘123’, LockedOutDate =null WHERE CompanyID = 2 AND Username = ‘admin’

  1. The user and password I am struggling with is the username as admin and password as setup.
    This is the username and password entered when the application is launched the very first time.

Leave a Reply

Your email address will not be published. Required fields are marked *