Copy data from SQL Server on prem to Azure SQL failing

[Danette]

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!

[v-karpurapud]

Hello @Danette 

Thank you for reaching out to Microsoft Fabric Community Forum.

Based on the error and the troubleshooting steps you've taken, it appears your issue is related to Azure networking and SQL connectivity rather than Microsoft Fabric. Posting your question in the Azure Q&A forum would be better as suggested by @lbendlin and @Vinodh247 .

Thank You.

[Danette]

Ok, thanks! I apologize for the mistake.

[Vinodh247]

maybe the question should be in the below forum, not here...

Ask a question - Microsoft Q&A

[lbendlin]

Maybe you want to post this in an Azure forum? Seems unrelated to Fabric.