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

sivaranjani somana 26 Reputation points
2021-01-27T17:52:36.743+00:00

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.

Azure SQL Database
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,751 questions
0 comments No comments
{count} votes

Accepted answer
  1. HarithaMaddi-MSFT 10,136 Reputation points
    2021-01-28T07:12:08.307+00:00

    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.

    61304-image.png

    Looking forward for your response!

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful