Share via

Azure Synapse pipeline copy data activity from on-prem to Azure sql db issue

Madhusudhana Rao Challapalli 40 Reputation points
2024-09-17T17:23:29.7766667+00:00

{

"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: '', Database: 'dbname', 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=2,Class=20,ErrorCode=-2146232060,State=0,Errors=[{Class=20,Number=2,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 system cannot find the file specified,Source=,'",

"failureType": "UserError",

"target": "SPName",

"details": []
```}
Azure SQL Database
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,997 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,842 questions
0 comments
Accepted answer
  1. NIKHILA NETHIKUNTA 3,265 Reputation points Microsoft Vendor
    2024-09-22T18:44:47.32+00:00

    @Madhu Challapalli
    I'm glad that you were able to resolve your issue and thank you for posting your solution so that others experiencing the same thing can easily reference this! Since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others ", I'll repost your solution in case you'd like to accept the answer .

    Ask: Receiving an error while trying to run a copy data activity in a pipeline where the source is an On-premises SQL DB.

    Solution: After recreating the Managed Private endpoints, the issue got resolved.

    If I missed anything please let me know and I'd be happy to add it to my answer, or feel free to comment below with any additional information.

    If you have any other questions, please let me know. Thank you again for your time and patience throughout this issue.

    Please don’t forget to Accept Answer and Yes for "was this answer helpful" wherever the information provided helps you, this can be beneficial to other community members.

    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Alberto Morillo 34,056 Reputation points MVP
    2024-09-17T18:31:05.8933333+00:00

    Please make sure the IP address of the Integration Runtime is whitelisted in your Azure SQL Server firewall. Verify you are allowing traffic on TCP port 1433 and the ports listed here.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.