Product: Dynamics GP (Standard/Advance)

Article Link: http://help.truecommerce.com/en/articles/6589891-dynamics-gp-standard-advance-error-a-network-related-or-instance-specific-error-occurred-while-establishing-a-connection-to-sql-server-the-server-was-not-found-or-was-not-accessible

Error: 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)

Issue: Whenever attempting to Import/Export or Sync to your Dynamics GP with Transaction Manager you an error indicating a network related or instance-specific error occurred and Transaction Manager was not able to connect to your SQL Server

Reason: Transaction Manager was not able to connect to your SQL Server - typically due to a blocked connection, outtage, or incorrect configuration with your SQL Server

Ensure the settings for your SQL Server are correct and verified within Transaction Manager

Navigate: Business System → (Company Name) → Company Configuration → Integration Options

Fill: Server, User, Password and GP Company Database for the SQL Server settings

Please be sure to restart the machine your SQL Server is hosted on before contacting TrueCommerce

Please be sure that any modifications recently made for security is not blocking traffic from TrueCommerce

Note: TrueCommerce does not maintain your connection to your environment or your SQL Server - please contact your IT Department to troubleshoot connection issues, and verify the SQL Server settings.

This error falls under the environmental category, and TrueCommerce is limited in their ability to help beyond showing you where the SQL Server settings within Transaction Manager reside

rev 9/26/22