Acumatica Configuration Wizard Database Configuration privileges error

  • 20 December 2020
  • 2 replies

Userlevel 1

In the Acumatica Configuration Wizard - Database Configuration, when using SQL Server Authentication, the error below appears. What privileges are needed, and how are they set?



Best answer by vkumar 21 December 2020, 10:37

View original

2 replies

Userlevel 7
Badge +19

Hi @dherr70,

Are you able to login into SSMS? If yes, are you providing the same logins in the configuration wizard?

Userlevel 7
Badge +11

Hi @dherr70 

As Naveen pointed out, check if you can access the database with the credentials used on Acumatica configuration wizard using SQL management studio. Error indicates that Acumatica configuration wizard has not been able to access SQL database using the credentials you have supplied.

You may also try create an instance using SQL admin credentials, i.e., user  Sa for testing. 

Let us know if it works.



About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved