When trying to run a copy activity using our Data Warehouse as a source and our On-Prem Server as a destination I get the following error when running the pipeline:
ErrorCode=SqlFailedToConnect,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Cannot connect to SQL Database. Please contact SQL server team for further support. Server: 'ed77kr5jwuyele3w7h56xuhncq-ylb4tq2xrxvu3arhjefqmovipi.datawarehouse.fabric.microsoft.com', Database: 'ef0332aa-2344-4c77-9bd9-3c3a0b174b71', User: ''. Check the connection configuration is correct, and make sure the SQL Database firewall allows the Data Factory runtime to access.,Source=Microsoft.DataTransfer.ClientLibrary,''Type=System.Data.SqlClient.SqlException,Message=A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server),Source=.Net SqlClient Data Provider,SqlErrorNumber=53,Class=20,ErrorCode=-2146232060,State=0,Errors=[{Class=20,Number=53,State=0,Message=A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server),},],''Type=System.ComponentModel.Win32Exception,Message=The network path was not found,Source=,'
We haven't been able to determine what this issue is. We are connecting through a gateway and to our knowledge no ports or URLs are being blocked. Just trying to see what step I'm missing here. When I preview data in the copy activity it pulls records successfully and mapping works so I know it's connected. It only fails when I run the copy activity to write to the destination.
