Home:ALL Converter>Azure SQL Database On-Premises Firewall Configuration for external data source

Azure SQL Database On-Premises Firewall Configuration for external data source

Ask Time:2016-08-15T01:43:03         Author:user3395924

Json Formatter

We have to add an on-premises SQL Server database table as external table in Azure SQL Database.

However, the on-premises firewall requires IP in whitelist to allow incoming connections. What IP does Azure database service use to connect for External Data source ? OR to put it differently, how do I configure our on-premises firewall to allow Azure to connect to on-premise databases through the External table configuration ?

Author:user3395924,eproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article:https://stackoverflow.com/questions/38944876/azure-sql-database-on-premises-firewall-configuration-for-external-data-source
yy