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,318 questions
How to fix an established connection was aborted by the server error while making SFTP connection using Azure Synapse?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(80, 64%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENP%3C/text%3E%3C/svg%3E)
Nikunj Patel
61
Reputation points
Hello Team,
While we are trying to connect SFTP using SSH public key authentication we are getting following error.
Established connection was aborted by the server
let me share the steps which we followed so far to connect the sftp.
[1] Open PuttyGen and Load SSH key
[2] Go to Conversion and select Export OpenSSH Key without password protect.
[3] Go to Azure synapse --> Select SFTP connection--> Pass Host name, Port, Username and upload Private Key content (file generated from step 2.) ( Disable Host key validation and Use self hosted Integration runtime)
[4] When test connection I am getting above error message.
Also we checked there were no IP address blocked for the SFTP host. so can anyone give any clue or thought why we are getting this connection abort error and how to fix it?
Thank you
Nik
Azure Synapse Analytics
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,464 questions
{count} votes
-
PRADEEPCHEEKATLA 90,606 Reputation points2023-02-24T11:02:26.7566667+00:00 @Nikunj Patel Thanks for the question and using MS Q&A platform.
Could you please share screenshot of the error message which you are experiencing?
Meanwhile, you can check out the Copy and transform data in SFTP server using Azure Data Factory or Azure Synapse Analytics.
-
PRADEEPCHEEKATLA 90,606 Reputation points
2023-02-27T07:32:56.1466667+00:00 @Nikunj Patel We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(208, 60%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Sarita Srivastava 5 Reputation points2023-08-04T10:00:16.6566667+00:00 Hello,
I am facing issue while connecting SFTP server using power automate.
while connecting SFTP getting message 'An established connection was aborted by the server'
Do we have any solution for this?
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 68%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJH%3C/text%3E%3C/svg%3E)
Jeff Hebrank 1 Reputation point Microsoft Employee2023-08-11T22:24:34.79+00:00 Just adding on because I am facing what sounds like the same issue.
I receive the error show below.
I verified that the private key and pass phrase are correct by connecting via the windows cmd line sftp utility and that connected successfully.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(48, 49%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
JKU 0 Reputation points2025-05-02T18:02:28.6566667+00:00 may 2025 here. Same error as user Jeff Hebrank above. Trying to connect to AWS transfer Family
Sign in to comment
Sign in to answer