Question
You are receiving an error when setting up your SQL Server destination warehouse:
Environment
Destination: SQL Server hosted on Microsoft Azure Virtual Machine
Answer
- In your Microsoft Azure console, navigate to Dashboard > Virtual machines > 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
We pull data from your source and send it to your destination using a set of fixed IP addresses. To ensure that Fivetran can do this, you must whitelist these IP addresses in your firewall/networking settings.