Faild to connect with SFTP server from azure linked service

Question

getting below error:

Meet authentication failure when connect to Sftp server 'sftp.XXXXX.XXXXX.com' using 'Basic' authentication type. Please make sure you are using the correct authentication type and the credential is valid. For more details, see our troubleshooting docs.

No suitable authentication method found to complete authentication (keyboard-interactive).

with winSCP, able to connect.

Answer 1

Hello Prakash Paul,

Welcome to the Microsoft Q&A forum.

Per the error message, SFTP server is not able to complete the authentication process using keyboard-interactive authentication.

To resolve this issue, can you try explicitly grant ADF to use keyboard-interactive authentication to establish SSH session in the schedule Copy.

Please follow the below steps to enable keyboard-interactive auth

• keyboard-interactive auth
  • On UX, click on Connections->Linked Services
  • Find the SFTP linked service you created
  • Click on the button heighted as right snapshot
• ’
• Remove encryptedCredential property, Add property allowKeyboardInteractiveAuth with value true, below is an example

Save the changes and rerun the copy

If this answers your question, please consider accepting the answer by hitting the Accept answer and up-vote as it helps the community look for answers to similar questions.