Credential recovery: doesn't sent email

​@bpgraves  Run the below script to update the Password

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

If you want to run it only for the particular tenant then add the “companyId” in the where condition.

https://asiablog.acumatica.com/index.php/2015/12/reset-user-password/

Hi ​@bpgraves,

The functionality is such that the system uses the default email that is specified on the user's profile. This overrides what is specified as the default email on the Email Preferences screen. If the default email on the Email Preferences and on user's profile are blank, then the recovery email will not be generated.

Also you can request an admin user to reset your password.

Hope this helps.

Hi ​@bpgraves 

Please run the following script into SSMS after changing your company id according to yours in it.
 

UPDATE dbo.Users
SET Password = 'Setup',
    LockedOutDate = NULL,
    LastLockedOutDate = NULL,
    FailedPasswordAttemptCount = 0,
    FailedPasswordAttemptWindowStart = NULL,
    PasswordRecoveryExpirationDate = NULL,
    PasswordChangeOnNextLogin = 0,
    PasswordNeverExpires = 1
WHERE Username = 'admin'
  AND CompanyID = 2;

After running try to login with 
Username: admin
Password: Setup

Thank You.

UPDATE dbo.Users
SET Password = 'Setup',
    LockedOutDate = NULL,
    LastLockedOutDate = NULL,
    FailedPasswordAttemptCount = 0,
    FailedPasswordAttemptWindowStart = NULL,
    PasswordRecoveryExpirationDate = NULL,
    PasswordChangeOnNextLogin = 0,
    PasswordNeverExpires = 1
WHERE Username = 'admin'
  AND CompanyID = 2;

This results in the same “Invalid credentials.  Please try again.” when I use CompanyID=2 but works fine when I use CompanyID=3.  There has to be some mapping that allows the credentials to work for particular tenants and not for others.  Do you know which table this is?

The default email account isn’t blank but the Notifications URL is incorrect.  Is this URL supposed to go to a certain page?  Which one?