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

[PaulineSP]

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.

[AntoineW]

Have you install a data gateway ? 

Do you have any firewall on your SQL Database ? 

[tayloramy]

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.