Connectivity issue with Data Factory and Azure SFTP

Question

I have enabled the private endpoint and approved it under the storage account private endpoint connections, from the linked services am able to test the connection to the storage account and its successful, but unable to connect to the SFTP client, facing below error

Provided hostname as <Storageacccountname>.blob.core.windows.net'.

username- <Storageacccountname>.<username>

Error:
Failed to connect to Sftp server 'sftptestpoc.blob.core.windows.net'.

The connection was closed by the server: - RequestId:a7912660-901e-0064-4da4-f73907000000 Time:2024-08-26T10:43:37.4542173Z (ByApplication).

Answer 1

Based on this old thread I found :

If you have tested and confirmed that your setup works in a non-production (non-prod) environment with the storage account firewall setting "enabled from all networks," but you are facing connectivity issues when testing from a public PC with an SFTP client in your production (prod) environment, there are several factors to consider in order to securely allow SFTP access from a public PC to your Azure Blob Storage in the production environment:

Firewall Settings: As for prod environment you have selected the storage account firewall setting as "enabled from selected networks ", please confirm that the public IP address of the PC from which you are attempting to connect is correctly included in the list of allowed networks in the Azure Blob Storage firewall settings.

SFTP Client Configuration: Please verify that your SFTP client is configured correctly to connect to Azure Blob Storage. Check that you are using the correct hostname, port (SFTP typically uses port 22), username and password. Ensure that your SFTP client uses secure SFTP protocols.

Public PC Firewall and Proxy: Kindly check if the public PC has any local firewall or proxy settings that might be blocking the SFTP connection. You may temporarily disable local firewalls for testing purposes and check. For limitation and known issues with SFTP, please refer: https://learn.microsoft.com/en-us/azure/storage/blobs/secure-file-transfer-protocol-known-issues If you've checked all these points and are still experiencing issues, it may be helpful to provide specific error messages or details about the issue you're encountering.