Azure / Azure/Azure-DataFactory

SFTP Meet authentication failure when connecting to Linux SFTP servers

Open
#488 2 comments 0 reactions 0 assignees View on GitHub
Dominant language
PowerShell
Stars
529
Forks
623
PR merge metrics
No merged PRs in 30d

Description

Hi,

I have been trying to test an SFTP linked service connection to Linux SFTP server, using SSH public key authentication, and an Azure generated SSH public key.

An example of the linked service configuration can be seen below...

![adf-sftp-config1](https://user-images.githubusercontent.com/40501541/205951133-b15086a9-b223-4923-9289-d78430c62917.PNG)

When testing this I connection the get the following error..

> Error code: SftpAuthenticationFailure
>
> Details: Meet authentication failure when connect to Sftp server '??.???.??.???' using 'SshPublicKey' authentication type. Please make sure you are using the correct authentication type and the credential is valid. For more details, see our troubleshooting docs. Permission denied (publickey).

However when testing to the same SFTP server using FileZilla, and the following configuration, the connection is successful.

![fz-sftp-config1](https://user-images.githubusercontent.com/40501541/205951909-0be6228e-3c20-4b58-83a6-dbdf21deec51.PNG)

Additionally, when using the same SSH public/private key pair, and authentication method, for an SFTP linked service connection to an SFTP enabled Azure storage container the connection is also successful.

I have tested this using the AutoResolveRuntime and a self-hosted integration runtime with identical results.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.