Azure SQL and Netlify

Hello,

I have a React application that uses a direct connection to Azure SQL. Azure SQL requires white-listed IP addresses, but I see that Netlify doesn’t have a static list of IP addresses that I can add to Azure.

Does anyone have any recommendations as to how I would allow Netlify servers to connect to my Azure SQL database? I have searched for this in both the forums and the wider internat, but I am not seeing anything…

Thanks,

James.

The only workaround that I can think of would be to set up an intermediate proxy (not hosted at Netlify) with a static IP address. Then you would have Netlify make the connection to the proxy and the proxy would then connect to the Azure SQL instance. The SQL server will only see the IP address of the proxy (which will be known and static) and not the IP addresses of the Netlify CDN nodes.