copydata activity getting error code 2200

Question

Hello All,

Pls help me to resolve this issue.

when I was run the copy data activity, I am getting the below error.

{
"errorCode": "2200",
"message": "ErrorCode=AdlsGen2OperationFailed,' Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException, Message=ADLS Gen2 operation failed for: An error occurred while sending the request.. Account: 'txcipsstacdwh'. FileSystem: 'txcipsstacdwh'..,Source=Microsoft.DataTransfer.ClientLibrary,''Type=System.Net.Http.HttpRequestException,Message=An error occurred while sending the request.,Source=mscorlib,''Type=System.Net.WebException,Message=The underlying connection was closed: An unexpected error occurred on a send.,Source=System,''Type=System.IO.IOException,Message=Authentication failed because the remote party has closed the transport stream.,Source=System,'",
"failureType": "UserError",
"target": "Copy data from sql to adls",
"details": []
}

Answer 1

Hi @Anonymous ,

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

As I understand your issue, you are facing error 'Authentication failed because the remote party has closed the transport stream' while trying to copy data from SQL server to ADLS .

Is your ADF is under managed vNet?

This could be a firewall issue from source side. Kindly make sure 'Allow Azure Services and resources to access this server' is set to No.

Additionally, you can leverage below resource s for better understanding:

How to access on-premises SQL Server from Data Factory Managed VNet using Private Endpoint
ADF copy data issue

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

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

• Please don't forget to click on or upvote 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