topic Re: Copy Job to copy On Premise SQL Server tables to Fabric SQL is failing in SQL database

Copy Job to copy On Premise SQL Server tables to Fabric SQL is failing

PaulineSP — Tue, 23 Dec 2025 11:07:27 GMT

I get this error after setting up a copy job to copy On Premise SQL Server tables to Fabric SQL Database

I have successfully seen this done on You Tube https://www.youtube.com/watch?v=Ae77yoGqqnM&t=300s
ErrorCode=SqlFailedToConnect,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Cannot connect to SQL Database. Please contact SQL server team for further support. Server: 'xxxxxxxxxxx.database.fabric.microsoft.com,1433', Database: 'xxxxxxxxxxx', User: ''. Check the connection configuration is correct, and make sure the SQL Database firewall allows the Data Factory runtime to access.

Re: Copy Job to copy On Premise SQL Server tables to Fabric SQL is failing

tayloramy — Tue, 23 Dec 2025 14:23:04 GMT

Hi PaulineSP,

Can you provide us some more details about the configuration?
Can you add screenshots of the set up?

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.

Re: Copy Job to copy On Premise SQL Server tables to Fabric SQL is failing

AntoineW — Wed, 24 Dec 2025 10:03:38 GMT

Have you install a data gateway ?

Do you have any firewall on your SQL Database ?

Re: Copy Job to copy On Premise SQL Server tables to Fabric SQL is failing

v-nmadadi-msft — Mon, 29 Dec 2025 06:13:00 GMT

Hi PaulineSP

I wanted to check if you had the opportunity to review the information requested by AntoineW and tayloramy . Please feel free to contact us if you have any further questions.

Thank you.

Re: Copy Job to copy On Premise SQL Server tables to Fabric SQL is failing

v-nmadadi-msft — Fri, 02 Jan 2026 05:35:33 GMT

Hi PaulineSP

May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.

Thank you

Re: Copy Job to copy On Premise SQL Server tables to Fabric SQL is failing

PaulineSP — Tue, 06 Jan 2026 16:23:53 GMT

The details are very simple - I am connecting to an On Premise SQL Server via an On Premise Gateway. The copy job allows me to connect to the on premise server, select the database and table I wish to copy, preview the contents of the table, view the column mappings, start the copy job but after about 1 minute the copy job timesout with the above error. I have tried both a Pipeline with copy job and a Dataflow Gen 2 but am unable to successfully copy data. I have now reported this to Microsoft and they are doing an investigation. I will update this forum when I get an answer from Microsoft

Re: Copy Job to copy On Premise SQL Server tables to Fabric SQL is failing

v-nmadadi-msft — Wed, 07 Jan 2026 04:52:11 GMT

Hi PaulineSP ,

We really appreciate your efforts and for letting us know the update on the issue.

Please continue using fabric community forum for your further assistance.

Thank you