Forum Discussion
Solved
Copy activity from on-prem to Fabric SQL Database
Hello I'm trying to run a copy activity in a Fabric pipeline to copy data from an on-prem SQL server to a Fabric SQL database via the on-premise data gateway. It's failing with the standard SQL erro...
The copy activity fails because the gateway VM cannot reach Fabric SQL Database—outbound port 1433 is blocked.
Fix:
Open TCP port 1433 outbound on the gateway.
Allow access to *.database.windows.net, *.sql.azuresynapse.net, and regional Fabric SQL endpoints.
Once done, the copy activity should work.
spaceman127
Super User
Super UserHello ian2x4b523p,
i set up an on-premises gateway and was then able to connect to my on-premises SQL Server without any problems.
I then configured the copy activity and copied data from the on-premises SQL Server to a Fabric SQL database.
Everything worked perfectly.
So your problem must definitely be something else. I hope I've been able to help you with this.
Best regards