Copy data from SQL Server on prem to Azure SQL failing

Hi!

I have been trying to solve this issue for some days now.

I need to copy some data from an on-prem SQL Server to an Azure SQL database using a Data Factory pipeline.

I successfully connected to both source (on-prem) and destination (Azure SQL). I can preview the destination table, but when executing the pipeline, it fails after a few minutes with the following error:

ErrorCode=SqlFailedToConnect,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Cannot connect to SQL Database. Please contact SQL server team for further support. Check the connection configuration is correct, and make sure the SQL Database firewall allows the Data Factory runtime to access.,Source=Microsoft.DataTransfer.ClientLibrary,''Type=System.Data.SqlClient.SqlException,Message=A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections.

I understand that network configurations are involved. We have opened the necessary firewall rules and created a private endpoint, but we might be missing something.

Could someone suggest what else to check?

Thank you!