Unable to load data from Azure Synapse Server less Pool to onPremise SQL Server

SrikarV 25 Reputation points
2023-11-29T10:59:09.07+00:00

I am not able to load data from Azure Synapse Server less SQL to On Premise SQL Server. But I am able to read the data from On Premise SQL Server to Azure Synapse.

Here we are created Private end points connections for serverless SQL pool in Azure synapse workspace.

Below is the error i am receiving.

{
    "errorCode": "2200",
    "message": "ErrorCode=SqlFailedToConnect,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Cannot connect to SQL Database. Please contact SQL server team for further support. Server: 'xxx-xx-xx-synapse-ondemand.sql.azuresynapse.net', Database: 'abc', User: ''. Check the linked service configuration is correct, and make sure the SQL Database firewall allows the integration 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=,'",
    "failureType": "UserError",
    "target": "Copy cloud data to server_copy1",
    "details": []
}
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,657 questions
{count} votes