How to access Azure SQL database from Azure Data factory to copy table from on-premise SAP ?

Madhavan Alagesan 6

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.

AnnuKumari-MSFT 31,061 Reputation points Microsoft Employee

2022-05-04T08:13:09.397+00:00

Hi @Madhavan Alagesan ,
Just following up to see if the above answer helped. Please do consider clicking Accept Answer as accepted answer helps community as well. Thanks!

1 answer

Nandan Hegde 29,896 Reputation points MVP

2022-04-27T08:47:48.467+00:00
Hey,
can you please test the below scenarios :

Test the linked service connections for the source and the sink

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
Please sign in to rate this answer.

1 person found this answer helpful.
Madhavan Alagesan 6 Reputation points

2022-04-27T11:20:11.297+00:00

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.

Nandan Hegde 29,896 Reputation points MVP

2022-04-27T11:24:13.147+00:00

Hey,
this is more on networking side rather than adf :)
there are 2 things which we need to do :

whitelist the IP of the IR server in Azure DB firewall

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

@Alberto Morillo : please add any points in case if missed out

Alberto Morillo 32,891 Reputation points MVP

2022-04-27T12:17:34.467+00:00

@Nandan Hegde and @Madhavan Alagesan 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.

AnnuKumari-MSFT 31,061 Reputation points Microsoft Employee

2022-04-29T16:16:36.407+00:00

Hi @Madhavan Alagesan ,
Just checking in to see if the above answer helped. Please do consider clicking Accept Answer and Up-Vote for the same as accepted answers help community as well. If you have any further query do let us know.

AnnuKumari-MSFT 31,061 Reputation points Microsoft Employee

2022-05-02T05:26:03.8+00:00

Hi @Madhavan Alagesan ,
Just following up to see if the above answer helped. Please do consider clicking Accept Answer and Up-Vote for the same as accepted answers help community as well. If you have any further query do let us know.
Sign in to comment