Product: 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. 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
Solution
SQL Settings - Transaction Manager
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
Restart SQL Server
Please be sure to restart the machine your SQL Server is hosted on before contacting TrueCommerce
Blocked Ports/Data
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