We run Acumatica 2020R2 and currently working on SQL Servers upgrade from 2012 to 2019. We have created new SQL Server 2019 and need to switch Acumatica production to it.
I have successfully connected to new SQL Server (SQL2) from my local instance, now test it on DEV. Acumatica Configuration Manager have successfully updated database, but when trying to open website I receive error:
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.
Parser Error Message: Login failed for user 'XXXXX\FEDXXX-DEV$'.
User 'XXXXX\FEDXXX-SQL$' is <Domain>\<DEV Server name>$
This user was NOT created on SQL2 server during switch. Both DEV and SQL2 servers are internal and don’t have any restrictions.
Best answer by nadiyahnatyuk58View original
@nadiyahnatyuk58 On the web.config in your local instance, try changing the connection string and verify.
Problem resolved by fixing database sever login for the IIS anonymous user:
@nadiyahnatyuk58 Thanks for the update.