Error code22665, DetailsFailed to connect to Sftp server 'securetransport.lithia.com'. Server response does not contain SSH protocol identification.

Sivalakshmana kumar Kolisetti 1 Reputation point
2022-05-19T01:10:26.063+00:00

Hi,

            We have a process that was set to run throughout the day and process files from and Azure File share to Azure Data Factory. The job/process runs fine throughout the day but fails between 5 PM – 6 PM Pacific ( 00:00 – 01:00 UTC). We are not able to find any issues with the IR server, the process, or the file share. Is this something you can help us figure out as to what is causing this to fail during that time frame? 

please help me how to overcome the issue

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,378 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. AnnuKumari-MSFT 34,556 Reputation points Microsoft Employee Moderator
    2022-05-19T09:01:15.603+00:00

    Hi @Sivalakshmana kumar Kolisetti ,

    Welcome to Microsoft Q&A platform and thankyou for posting your query.

    As I understand your issue, you are facing error: "Server response does not contain SSH protocol identification." while trying to process data from SFTP server. Please correct me if my understanding is incorrect.

    Cause: If the error message contains the string "Server response does not contain SSH protocol identification", one possible cause is that the SFTP server throttled the connection. Multiple connections are created to download from the SFTP server in parallel, and sometimes it will encounter SFTP server throttling. Ordinarily, different servers return different errors when they encounter throttling.

    Recommendation:

    Specify the maximum number of concurrent connections of the SFTP dataset as 1 and rerun the copy activity. If the activity succeeds, you can be sure that throttling is the cause.

    If you want to promote the low throughput, contact your SFTP administrator to increase the concurrent connection count limit, or you can do one of the following:

    • If you're using Self-hosted IR, add the Self-hosted IR machine's IP to the allowlist.
    • If you're using Azure IR, add Azure Integration Runtime IP addresses. If you don't want to add a range of IPs to the SFTP server allowlist, use Self-hosted IR instead.

    Please go through this troubleShoot guide for more details.

    Hope this will help. Please let us know if any further queries.

    ------------------------------

    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you.
      Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
    • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators
    1 person found this answer helpful.

  2. Sivalakshmana kumar Kolisetti 1 Reputation point
    2022-05-23T15:39:08.893+00:00

    Hi,

    Any update please help me to resolve the issue.

    Regards,
    Siva

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.