When creating the integration the following error occurs:

Connecting to server. Failed to create the configuration

The following query returns the correct server name:

select * from Custom_SysParams where Parm_Name like ('%servernames%') or Parm_Name like ('%links%')

Work around / Resolution:

This issue was resolved by deactiviating “Windows authentication” on the ERP side for the website “Sage ERP”.