Can't setup SFTP connection on Data Factory V2, I got TimeOut Error. RRS feed

  • Question

  • Hi,

    I would like to set up a copy activity on my Data Factory V2 from an SFTP VM On Azure to an Azure Data Lake Storage,  but I got always a time Out Error when I try to configure the SFTP Connection as a source with the basic steps.

    is there any best practices to set up this connection ? or any other ways to do this ? 

    Error : Meet network issue when connect to Sftp server 'xx.xx.xx.xx', SocketErrorCode: 'TimedOut'.

    SFTP code :

    "name": "SftpConnection",
    "type": "Microsoft.DataFactory/factories/linkedservices",
    "properties": {
    "type": "Sftp",
    "typeProperties": {
    "host": "xx.xx.xx.xx",
    "port": 22,
    "skipHostKeyValidation": true,
    "authenticationType": "SshPublicKey",
    "userName": "sftpaccount",
    "encryptedCredential": "OpenSSH KEY FORMAT"
    Tuesday, December 4, 2018 9:36 AM

All replies

  • Hi NFD-MA,

    Can you please verify a couple of things : 

    1. Port 22 is inbound open on the SFTP VM.
    2. The credentials are correct - you can verify this by clicking on "Test Connection" in the linked service that you create for the SFTP source.
    Tuesday, December 4, 2018 12:18 PM