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!
Hi,
When i install Acumatica in MS SQL, i don’t see any user name “admin” in MS SQL.
I know “admin” exist because i can log into other tenant with using admin, but one of tenant i have a problem log in and try to reset password, but I don’t see admin.
Am I missing something?
Never mind, I didn’t know they have a separate table “user” inside of database..
I’m a new here 🙂
Why i cant change new password and confirm password
It saya “invalid credentials”
This didn’t work for me : was there something that I needed to select?
UPDATE Users SET Password = ‘123’, LockedOutDate =null WHERE CompanyID = 2 AND Username = ‘admin’
Error : Invalid object name : ‘Users’
Any help – just downloaded and installed
Invalid object name : ‘Users’ means there is no table users. Execute this query in the scope of Acumatica database.
use [AcumaticaDB]
Has this procedure changed with 2020R1?
Nope, it is the same across all the versions.
Still the same. I’ve just use the script on 2020R1.
and if it is a different tenant, how would it be?
Hi Carlos, add CompanyID = to the where statement, like here:
UPDATE Users SET Password = ‘123’, LockedOutDate =null WHERE CompanyID = 2 AND Username = ‘admin’
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.
Really Useful ! Thanks
It's really helpful
Thank you