I am trying to copy from the on-premises sap table to the Azure SQL database using Azure Data Factory.
Integration runtime is running on VM and added this IP in SQL server client IP.
Error:
Check the linked service configuration is correct, and make sure the SQL database firewall allows the intergration runtime to access.
Hi @MadhavanAlagesan-5764 ,
Just following up to see if the above answer helped. Please do consider clicking Accept Answer as accepted answer helps community as well. Thanks!
Hey,
can you please test the below scenarios :
1) Test the linked service connections for the source and the sink
2) If the linked service connections are successful and the issue is only during copy activity,
test whether you are able to access the source and sink within the IR because whenever we use copy activity with an IR, both source and sink must be accessible via IR
Yes. I am not able to access the Azure SQL Database from IR.
Can you please tell me what should I do?
I am new to ADF.
Hey,
this is more on networking side rather than adf :)
there are 2 things which we need to do :
1) whitelist the IP of the IR server in Azure DB firewall
2) You need to open ports in the server to access Azure SQL db
Azure SQL Database communicates over port 1433. If you're trying to connect from within a corporate network, outbound traffic over port 1433 might not be allowed by your network's firewall
@AlbertoMorillo : please add any points in case if missed out
@NandanHegde-7720 and @MadhavanAlagesan-5764 Nandan the first item you mentioned about configuring Azure SQL database firewall to the intergration runtime to access the database would be my first suggestion also.
Also consider to enabled the "Allow Azure services and resources to access this server" option on Azure SQL firewall, just in case it may be needed.
16 people are following this question.
