An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
Hello Kishor kumar Reddy Akki
This is a documented limitation with Self-Hosted Integration Runtime (SHIR) when Windows FIPS mode is enabled.
Microsoft specifically documents that Copy Activity can fail for connectors including SFTP with:
This implementation is not part of the Windows Platform FIPS validated cryptographic algorithms.
The documented workaround is to add: <enforceFIPSPolicy enabled="false"/> to diawp.exe.config and restart SHIR. However, this bypasses .NET FIPS enforcement for the SHIR process, so it does not meet a requirement where FIPS enforcement must remain enabled.
Updating SHIR is generally recommended, but the current documentation still lists this FIPS issue.
If not consider using Azure Integration Runtime instead of SHIR where network connectivity permits. The SFTP connector supports both Azure IR and SHIR, and Microsoft also documents Managed VNet IR as an option for private network access.
Official documentation: