Skip to main content
Answer

can't establish connection to the database server

  • May 17, 2023
  • 5 replies
  • 1441 views
Michael Ndungi
Varsity I
Forum|alt.badge.img

Hello everyone,
I'm trying to connect Sql server in a DB server to App server so as to create the application ERP but i get this error.
Kindly assist.
 






A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
 --------------------------------------
 Inner Exception:
 The network path was not found

Best answer by Naveen Boga

Hi @development93  Please check the below options.

 

  1. Check SQL Server service is running
  2. Make sure that Allow Remote Connections is enabled on sql server properties
  3. Configure to allow SQL Server in Firewall Settings
  4. Make sure that you can ping the SQL Server
Michael

    5 replies

    RohitRattan88
    Acumatica Moderator
    Forum|alt.badge.img+4
    • RohitRattan88
    • Acumatica Moderator
    • May 17, 2023

    are you able to ping your DB server, sql service from erp server? Error seems to be network related. I would first try to see if you can ping/reach both servers back and forth.

    Chris Hackett
    Naveen Boga
    Captain II
    Forum|alt.badge.img+19
    • Naveen Boga
    • Captain II
    • Answer
    • May 17, 2023

    Hi @development93  Please check the below options.

     

    1. Check SQL Server service is running
    2. Make sure that Allow Remote Connections is enabled on sql server properties
    3. Configure to allow SQL Server in Firewall Settings
    4. Make sure that you can ping the SQL Server
    Naveen B - Acumatica MVP 🏆 | Independent Developer for Hire 🚀 ⏩ https://www.linkedin.com/in/boga-naveen-kumar-54079a66/
    Chris Hackett
    Michael Ndungi
    Varsity I
    Forum|alt.badge.img

    SQL server service is running, remote connection is enabled, I enabled required ports on the firewall.I can connect to the sql server using username and password in DB server.
    When I ping the DB server from ERP server I get response but when ,I ping ERP server from the DB server- No response.
    I.e
     

     

    Michael
    Michael Ndungi
    Varsity I
    Forum|alt.badge.img

    are you able to ping your DB server, sql service from erp server? Error seems to be network related. I would first try to see if you can ping/reach both servers back and forth.

    DB server cannot reach ERP server,
    But
    ERP server is getting a reply from DB server by ping

    Michael
    Michael Ndungi
    Varsity I
    Forum|alt.badge.img

    Hi@RohitRattan88 and @Naveen Boga , you were both right , I cross-checked what you had pointed pointed out. Reconfigured TCP/IP in sql server and Everything worked.

    Thanks alot

    Michael
    Chris Hackett
    Terms & ConditionsCookie settingsAccessibility statement
    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