Skip to main content
Solved

Acumatica database - SQL Server Upgrade from 2012 to 2019

  • 2 November 2021
  • 3 replies
  • 281 views

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:

Configuration 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 nadiyahnatyuk58

Problem resolved by fixing database sever login for the IIS anonymous user:

 

View original
Did this topic help you find an answer to your question?

3 replies

Forum|alt.badge.img+9
  • Semi-Pro I
  • 714 replies
  • November 2, 2021

Hi @nadiyahnatyuk58 On the web.config in your local instance, try changing the connection string and verify.

Thanks


  • Author
  • Jr Varsity II
  • 9 replies
  • Answer
  • November 2, 2021

Problem resolved by fixing database sever login for the IIS anonymous user:

 


Forum|alt.badge.img+9
  • Semi-Pro I
  • 714 replies
  • November 2, 2021

Hi @nadiyahnatyuk58  Thanks for the update.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings