Acumatica – Can’t establish connection to database server

By | December 29, 2021

Acumatica ERP allows us to connect database server using Windows Authentication as well as SQL Server Authentication. There are some SQL configuration settings which needs to be handled for seamless connectivity of Acumatica with SQL server.

In this blog, we will be looking into one of the resolutions for the error that occurs at the time of configuring the Acumatica Instance.

While creating new Acumatica Instance, the initial step is to create database server connection as shown in the below image.

Database Server Connection

The below screenshot demonstrates the connectivity with “SQL Server Authentication” and the same issue appears if “Windows Authentication” is selected instead of SQL server.

SQL Server authentication

On click of Next button the error will pop up as below.

Error: – “Can’t establish connection to database server”.

The left section of the below screenshot displays the Inner Message of an error whereas the right section displays the stack trace.

Acumatica Config Wizard

Steps to resolve the above error are as follows:

  1. Open SQL Server Configuration Manager on which we have configured the Acumatica Database.
  2. Navigate to “SQL Server network Configuration” > Protocols for SQL > TCP/IP.
  3. Make sure that the TCP/IP is in Enabled mode.
  4. Double Click on TCP/IP to open the Properties dialog box.
  5. Move on the “IP Addresses” tab.
  6. Scroll to the end of the list and ensure that the IPALL has TCP Port value as 1433.
  7. Once done, restart the SQL Server and proceed with creating the database instance again.

TCP Port

This is how we can resolve the connection issue while creating the database instance for Acumatica ERP.

About Us

Greytrix – a globally recognized and one of the oldest Sage Development Partner is a one-stop solution provider for Sage ERP and Sage CRM organizational needs. Being acknowledged and rewarded for multi-man years of experience and expertise, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third party add-on development and implementation competence.

Greytrix has a wide product range for Sage Intacct- a Cloud ERP. This includes migrations from QuickBooks | Sage 50 | Sage 100 | Sage 300 to Sage Intacct. Our unique GUMU™ integrations include Sage Intacct for Sage CRM | Salesforce | FTP/SFTP | Rev.io | Checkbook | Dynamics 365 CRM | Magento | Rent Manager | Treez | Avalara Avatax | Blackline SFTP. We also offer best-in-class Sage Intacct Development Services, Consulting services, integrated apps like POS | WMS | Payroll | Shipping System | Business Intelligence | eCommerce for Sage Intacct to Sage business partners, resellers, and Sage PSG worldwide. Greytrix constantly develops apps, products, and add-ons to enhance user experience. Sage Intacct add-ons include AR Lockbox File Processing. Greytrix GUMU™ integration for Sage CRM – Sage Intacct, Sales Commission App for Sage Intacct, and Checkbook.io ACH/Digital Check Payments for Sage powered by GUMU™ are listed on Sage Intacct Marketplace.

The GUMU™ Cloud framework by Greytrix forms the backbone of cloud integrations that are managed in real-time for the processing and execution of application programs at the click of a button.

For more information on Sage Business Cloud Services, please contact us at sagecloud@greytrix.com. We will like to hear from you.