IP address is coming dynamic but want static in Azure data factory to copy data from rest api to azure Sql db

Question

Hi,

I have created a pipeline to dynamically load data from rest api to azure Sql Db.
To achive this initially i have created a db in which all urls and specific table to which it need to load has been given followed by other table for schema mapping. But when am trying to run the pipeline to collect the url's and schema mapping it is working fine but while trying to copy the data it is throwing error as "Client with IP address '20.42.2.118' is not allowed to access the server. To enable access, use the Windows Azure Management Portal or run sp_set_firewall_rule on the master database to create a firewall rule for this IP address or address range. "and when i have added this IP in db firewall for the next run it is creating a new ip again. So for each run am getting new IP address and it is failling. How to fix this. Please help me with this issue.

Answer 1

Hi @sivaranjani somana ,

Welcome to Microsoft Q&A Platform. Thanks for posting the query.

Please suggest if the below indicator is enabled which will allow ADF to access Azure SQL every time without enabling the firewall.

Looking forward for your response!