Using HTTPS Connections with the Sage 50 Accounts Connector v2.5

Summary

The Sage 50 Accounts Connector tool is able to communicate with the Sage 50 Accounts server over HTTP and HTTPS. HTTP communication is enabled by default.

This article describes how to configure both the Sage 50 Accounts and the BPA Platform servers to use HTTPS.

Note: The following is only applicable to version 2.5 or above of the Sage 50 Accounts Connector tool.

Prerequisites

Ensure your Sage 50 Accounts infrastructure is set up for HTTPS communication using trusted certificates and TLS 1.2

Note that the version of TLS used is dependent on the configuration of the Sage 50 Accounts server — the Sage 50 Accounts Connector will match the protocol.

Procedure

Step 1: (Optional) Change the Communication Port Number

By default, the Sage 50 Accounts Connector communicates over port 4106 when using HTTPS. If a different port number is required, do the following:

  1. From the Sage 50 Accounts server, go to the Sage 50 Accounts Connector installation folder (by default, this is C:\Program Files(x86)\Codeless Platforms\Sage 50 Accounts Connector Toolpack\Integration Service).
  2. Open Sage 50 Accounts Integration Service.exe.config in a text editor such as Notepad. Ensure you run the text editor as Administrator otherwise you cannot save the file properly.
  3. Change the value for HttpsServiceUri to the required port number.
  4. Save this change.
  5. Go to Control Panel > Administrative Tools > Services.
  6. Restart the Sage 50 Accounts Integration service.

Step 2: Bind the Trusted Certificate to the Communication Port

From the Sage 50 Accounts server that is hosting the Sage 50 Accounts Integration Agent, do the following:

  1. Import the trusted certificate to the Sage 50 Accounts server.
  2. Open a command prompt as the Administrator.
  3. Enter the following command:

    netsh http add sslcert ipport=0.0.0.0:<port_number> certhash=<certificate_hash_value> appid={4d159978-4574-4dd5-b3ff-6f7fc8c20344}

    where:

    • port_number is the TCP port number used to communicate with the Integration Agent (default of 4106)
    • certificate_hash_value is the hash value from the certificate, otherwise known as the “thumbprint”

For more information about using the add sslcert command, refer to the Microsoft MSDN article – add sslcert.

Step 3: Enable HTTPS in the Sage 50 Accounts Connector Connection

For Existing Connections

Existing connections to this particular Sage 50 Accounts Connector Integration Agent must be changed to use HTTPS; do the following:

  1. Open the connection’s global configuration.

    You may experience a delay before the configuration opens as the Sage 50 Accounts Connector waits for the connection to the Integration Agent to timeout first.

  2. From the Connection Settings tab, click Advanced.
  3. Enable Use HTTPS.
  4. If communication is over a custom TCP port number (see Step 1), enable Set custom port number and enter the new port number below.
  5. Click OK.
  6. Go to the Company tab.
  7. You must re-select the Company database the Integration Agent is monitoring.
  8. Click OK.

For New Connections

New connections to this particular Sage 50 Accounts Connector Integration Agent must be over HTTPS. When adding the global configuration for this Agent, do the following to ensure communication is over HTTPS:

  1. From the Connection Settings tab, click Advanced.
  2. Enable Use HTTPS.
  3. If communication is over a custom TCP port number (see Step 1), enable Set custom port number and enter the new port number below.
  4. Click OK.