Issue
An error appears while setting up your SQL Server destination warehouse:
Environment
Destination: SQL Server hosted on Microsoft Azure Virtual Machine.
Resolution
- In your Microsoft Azure console, navigate to Dashboard > Virtual machines, then select your virtual machine.
- Under Settings on the left-hand side, click on Networking.
- Add inbound port rules.
- Whitelist all Fivetran IP Addresses listed for your region.
Cause
Fivetran pulls data from your source and sends it to your destination using a set of fixed IP addresses. To make sure that Fivetran can do this, you must whitelist these IP addresses in your firewall/networking settings.