Skip to main content
Question

Cannot sign in to new U100 instance

  • July 10, 2025
  • 5 replies
  • 91 views

I just setup a test instance using the U100 dataset and I cannot sign into the admin account. I have tried username: admin and password: setup as well as password: 123 and username: gibbs/password: 123. 

 

I did encounter a few errors that I had to ignore to get this instance off the ground. There were a few tables in the database that the system had trouble loading data into and I had to skip over them to get the instance to finish setting up. Normally when that happens the usual admin login works and just loads the instance with no data or pre-configuration. 

 

Edit: Just checked the database and somehow no user data made it into the tenant at all. I’ve been having a lot of issues starting new instances and tenants with pre-loaded data, it will just selectively decide not to load data into certain tables and in the end I either have to cancel the task altogether or continue creating the instance with no data. Has anyone else dealt with this issue? 

5 replies

Forum|alt.badge.img+3
  • Acumatica Support Team
  • July 10, 2025

Hey Shelby, 

Since this is a local install, the password can be updated in SQL via scrip using SSMS.
something like this should work to change admin password to 123
The other option would be to reload Sales Demo data into a new database in SQL via ERP configuration wizard. 

Update users set password = '123', PasswordChangeOnNextLogin =0, PasswordNeverExpires =1, LastLockedOutDate=NULL, FailedPasswordAnswerAttemptCount=0,FailedPasswordAttemptWindowStart=NULL,PasswordRecoveryExpirationDate=NULL where source = 0 and username = 'admin'
 


mohammadnawaz51
Jr Varsity I
Forum|alt.badge.img+4

@shelbyf 

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.


Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+15

@shelbyf What Kind of errors you are getting? Please Update your password as ​@Missy Main Mentioned.


  • Author
  • Freshman I
  • July 10, 2025

@Manikanta Dhulipudi 

It says: “Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Table name: APTran. File name:  . Line number: 0.”


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • September 24, 2025

Hi ​@shelbyf were you able to find a solution? Thank you!