An Azure service for ingesting, preparing, and transforming data at scale.
The failure is most likely due to SSH algorithm compatibility during the actual copy session, not a basic connectivity problem.
Server HMAC algorithm not found indicates the SFTP server is offering HMAC algorithms that Azure Data Factory does not support for the copy operation. A similar accepted Microsoft Q&A answer states that ADF does not support the -etm HMAC variants required by some SFTP servers, and when the server does not offer a compatible algorithm, the connection fails.
Why test connection or preview can appear to work while Copy fails:
- They are not guaranteed to exercise the same transfer path. Test connection validates that ADF can reach the server and complete a basic connection check.
- Preview is a lighter operation. It may succeed slowly while the full copy activity opens transfer sessions that require algorithm negotiation the server rejects.
- Copy can create multiple connections. ADF can open parallel connections during download, and the SFTP troubleshooting guidance notes that multiple parallel connections can trigger server-side throttling or different SSH/SFTP failures.
Actions to try on the ADF side first:
- Confirm the linked service type is SFTP
Make sure the linked service is
Sftp, not FTP. The SFTP linked service default port is 22 unless the server uses a different port. - Limit concurrency to 1 In the SFTP dataset or copy settings, set maximum concurrent connections to 1 and rerun the copy. This is specifically recommended when copy fails but connection behavior is inconsistent, because parallel connections can trigger server throttling.
- If writing to SFTP, disable temp-file rename only when rename is unsupported
This does not apply to reading from the client SFTP source, but it matters if the destination is also SFTP and errors such as
UserErrorSftpPathNotFound,UserErrorSftpPermissionDenied, orSftpOperationFailoccur during write. - Validate the server’s supported SSH/HMAC settings with the client If concurrency = 1 does not help, the remaining likely cause is cryptographic incompatibility on the server side. In that case, the client must enable an algorithm supported by ADF, or a bridge pattern is needed.
What this means for resolution:
- If reducing concurrent connections to 1 fixes it, the issue is likely server throttling during copy.
- If it still fails with
Server HMAC algorithm not found, this is a server/ADF compatibility issue rather than an ADF misconfiguration. - In that case, the practical options are:
- ask the client to enable an ADF-compatible algorithm on the SFTP server, or
- use an intermediary such as an Azure VM or Azure Function App to pull from SFTP and then hand off to ADF through a supported store such as HTTPS or Azure Blob Storage.
- Troubleshoot the FTP, SFTP, and HTTP connectors in Azure Data Factory and Azure Synapse
- Copy and transform data in SFTP server using Azure Data Factory or Azure Synapse Analytics
- Copy and transform data in SFTP server using Azure Data Factory or Azure Synapse Analytics
- Failed to connect to Sftp server Server HMAC algorithm not found. Azure Data Factory - Microsoft Q&A
- SftpFailedToConnectToSftpServer - Microsoft Q&A