Error: Unable to Connect to Host

Issue

Connection tests fail. The following error appears:

Unable to connect to host. Connection error: Connect timed out

Environment

• All database connectors
• Connection option: AWS PrivateLink

Resolution

To resolve this issue, do the following:

1. Ensure you have provided us with the correct port number.

   i. In Fivetran, go to your database connector page.

   ii. Select the Setup tab.

   iii. Click Edit connection.

   iv. Ensure the Port value matches your load balancer's port number.

   v. If you have made any changes, click Save & Test.

2. In your AWS Management Console, ensure the Network Load Balancer status is set to Active.

3. Ensure the Network Load Balancer's Scheme configuration is set to Internal. For more information, see AWS' Create a Network Load Balancer documentation.

4. Ensure the target associated with your Network Load Balancer has a Healthy health status. For more information, see AWS' Check the health of your Network Load Balancer targets documentation.

5. Ensure your Network Load Balancer's Availability Zones match your database's Availability Zones. For more information, see AWS' Update Network Load Balancer Availability Zones documentation. Alternatively, enable cross-zone load balancing.

6. If you utilize security groups with your Network Load Balancer, ensure they are configured to allow our internal CIDR range: 10.0.0.0/8. For more information, see AWS' Update Network Load Balancer Security Groups documentation.