By using this website, you agree to our Terms of Use (click here)
Just upgraded from 2019R2 to 2020R1 and I am not able to login to any of my other tenants. They show up when using the Acumatica configuration wizard but are not available for login.
Any ideas?
I've seen this quite a few times with our clients who have multiple tenants. For some reason some of the tenants will be marked as read-only and they lose their company key. If you have access to the database you can fix this yourself with the following steps.
1. Open SQL management studio and connect to the server and database.
2. Execute the statement
select * from Company
3. Find any CompanyIDs greater than 1 that have IsReadOnly=1 and CompanyKey blank or NULL and run the following statement for each CompanyID. You will need to put in a new CompanyKey and the proper CompanyID
update Company set IsReadOnly=0, CompanyKey='NEWCOMPANYKEY' where CompanyID=3
4. You will need to logout and the companies should show up now. If not, then restart the application via the Apply Updates screen.
