Unable to Authenticate to SFTP server from Azure Data Factory

Question

I am trying to create a link service to an SFTP server. When I test the connection I get the error:

I believe the failed connection is because sftp server does not recognize the Azure Integration Runtime IP address. I say this because I can successfully connect using any SFTP client such as WinSCP.

Therefore, can someone let me know how to obtain the Azure Integration Runtime IP address please? My Link Service looks like the following:

Answer 1

Looking at your error, If access is restricted to IPs that are not whitelisted in your SFTP server's firewall rules, it may be connected to a firewall issue. Make sure you whitelist such IPs. Adding Azure Integration Runtime IPs to the allow list is an option if you're utilizing Azure IR.

can someone let me know how to obtain the Azure Integration Runtime IP address please?

To get the Azure IP ranges you can follow this doc Azure IP Ranges and Service Tags – Public Cloud

As per Microsoft document,

maxConcurrentConnections : The upper limit of concurrent connections established to the data store during the activity run. Specify a value only when you want to limit concurrent connections.

You can adjust your Source's and sink's Max concurrent connection value to be lower than the SFTP concurrent connection limit set by the SFTP admin.