SFTP error when connecting from Azure Data Factory

Question

SFTP error when connecting from Azure Data Factory

Koen van Wielink 20

When testing a connection from Azure Data Factory to an SFTP server which I created on a storage account, I receive the following error when creating the linked service:

Meet network issue when connect to Sftp server '<saaccountname>.<sftpuser>@<saacountname>.blob.core.windows.net', SocketErrorCode: 'NoRecovery'. A non-recoverable error occurred during a database lookup

The SFTP server is using the SFTP feature of an Azure Storage account. The storage account has public network access enabled from all networks. The SFTP user is set to authenticate with an SSH key pair and has sufficient permissions to read and write files. The SSH key is base64 encoded and stored in a key vault secret.
When using the same SFTP user and SSH key I am able to connect using Filezilla from my local machine and transfer files, so I know the SFTP server is working.

The configuration in ADF for the linked service is as follows:

User's image

Any help as to why I am getting this error would be greatly appreciated.

J N S S Kasyap 2,040 Reputation points Microsoft External Staff Moderator

2025-05-07T08:35:45.7133333+00:00

@Koen van Wielink
Just checking in to see if the below answer helped. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Accepted answer

0 additional answers

Your answer

J N S S Kasyap 2,040 Reputation points Microsoft External Staff Moderator

2025-05-07T08:35:45.7133333+00:00

@Koen van Wielink
Just checking in to see if the below answer helped. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Answer 1

Hi @Koen van Wielink

The SFTP server address should not include the username. Including the username in the host field leads to DNS resolution issues, resulting in the 'NoRecovery' socket error.

User's image

Host: <saaccountname>.blob.core.windows.net
This is the correct format for the Azure Storage SFTP endpoint.

The SFTP connector supports an RSA/DSA OpenSSH key. Make sure that your key file content starts with "-----BEGIN [RSA/DSA] PRIVATE KEY-----". If the private key file is a PPK-format file, use the PuTTY tool to convert from PPK to OpenSSH format.

Ensure that ADF can access the SFTP endpoint over port 22. If you're using a Self-hosted Integration Runtime (SHIR), make sure the machine hosting the SHIR can reach the storage account's SFTP endpoint.

Please refer the below Microsoft Doc for more information
https://learn.microsoft.com/en-us/azure/data-factory/connector-sftp?tabs=data-factory
https://learn.microsoft.com/en-us/azure/data-factory/connector-troubleshoot-ftp-sftp-http

I hope this information helps. Please do let us know if you have any further queries.

Kindly consider upvoting the comment if the information provided is helpful. This can assist other community members in resolving similar issues.

Koen van Wielink 20 Reputation points

2025-05-07T07:02:02.97+00:00

Thank you very much for that answer! Initially I still got another error saying that the username was invalid, but a quick further search told me I needed to add the storage account name in front of it, so <storageaccountname>.<username> in the username property.
Koen van Wielink 20 Reputation points

2025-05-07T09:16:50.9166667+00:00

All solved

Share via

SFTP error when connecting from Azure Data Factory

0 additional answers

Your answer