Forum Discussion
COPY DATA FROM ON-PREM SQL Database to Azure SQL Database
Hi ivamsikrishna
It looks like the error is due to a network issue between Microsoft Fabric and your on-prem SQL Server—most likely from the gateway (Self-hosted Integration Runtime). Make sure the gateway is running and can connect to your SQL Server (you can test it using SSMS on the same machine). You can also try using Dataflow Gen2 as a workaround, which sometimes avoids these connection issues.
Regards,
Mehrdad Abdollahi
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.
Hope everything’s going smoothly on your end. We haven’t heard back from you, so I wanted to check if the issue got sorted. If yes, marking the solution would be awesome for others who might run into the same thing.