Copy Data with VNET gateway error

Hi TK12345 ,

Before continuing the investigation, we need to clarify a couple of things.

Are you using Azure SQL Database / Azure SQL Managed Instance in the cloud, or is it a SQL Server on a VM or on-premises environment? Depending on this, the diagnosis changes:

• If it is on-premises, first verify that the gateway is active and working correctly, as a gateway with issues can allow preview to work but fail when running the full pipeline execution.
• If it is Azure cloud, although using the VNET is valid and adds an extra security layer, try creating the same Copy Data activity using a direct connection without the VNET. If the pipeline works correctly with that direct connection, the problem is confirmed to be in the gateway and not in the source or destination.

In any case, verify that the connection is correctly configured and in active status from the Connections section in Fabric before running the pipeline again.

This is the quickest way to identify where the error is really coming from.

Hope this helps.

If my comments helped solve your question, it would be great if you could like the two comments and mark it as the accepted solution. It helps others with the same issue and also motivates me to keep contributing.

Thanks a lot, I really appreciate it.