ADF pipeline is failed connecting to Azure SQL

Mandya Krishna, Vikyath 1 Reputation point
2022-09-23T07:44:50.27+00:00

we are running a job to load the data from SQL Source to D365 Sink which runs for several hours and loads the data but intermittently SQL source connection was forcibly closed by the error message posted below

SQL DB is configured with 100 DTUs and utilization looks normal. and tried increasing the DTUs to 200 but faced similar issue

Connectivity configuration:
in the below image
244135-image.png

Error Message

Failure happened on 'Source' side. ErrorCode=SqlOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=A database operation failed with the following error: 'A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)',Source=,''Type=System.Data.SqlClient.SqlException,Message=A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.),Source=.Net SqlClient Data Provider,SqlErrorNumber=10054,Class=20,ErrorCode=-2146232060,State=0,Errors=[{Class=20,Number=10054,State=0,Message=A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.),},],''Type=System.ComponentModel.Win32Exception,Message=An existing connection was forcibly closed by the remote host,Source=,'

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,234 questions
{count} votes

3 answers

Sort by: Most helpful
  1. AnnuKumari-MSFT 34,011 Reputation points Microsoft Employee
    2022-09-23T09:02:05.547+00:00

    Hi @Mandya Krishna, Vikyath ,

    Thankyou for using Microsoft Q&A platform and thanks for posting your question here.

    As I understand your issue, Azure SQL connection failed with the above mentioned error while loading the data from Az SQL server to D365 .

    This can be a transient error, kindly try running the pipeline after some time. Also, kindly make sure the following points have been taken care while you are using Redirect connectivity configuration:

    • Allow outbound communication from the client to all Azure SQL IP addresses in the region on ports in the range of 11000 to 11999. Use the Service Tags for SQL to make this easier to manage.
    • Allow outbound communication from the client to Azure SQL Database gateway IP addresses on port 1433.
    • When using the Redirect connection policy, refer to the Azure IP Ranges and Service Tags – Public Cloud for a list of your region's IP addresses to allow.

    Hope this will help. Please let us know if any further queries.

    ------------------------------

    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you.
      Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
    • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators
    0 comments No comments

  2. Mandya Krishna, Vikyath 1 Reputation point
    2022-09-26T19:13:16.56+00:00

    This answer is really not helpful. It was a copy paste from azure documentation, which we are already following.

    Issue was with azure sql server network which MS networking team is working on the fix.

    Thank you.


  3. Mandya Krishna, Vikyath 1 Reputation point
    2022-10-14T08:10:28.44+00:00

    @James Lovegrove No It did not. we are still facing the same issue.


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.