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.
Shahid12523
Community Champion
Community ChampionThe 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.
thank you
