This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(188.79999999999998, 1%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESP%3C/text%3E%3C/svg%3E)
Hello,
my Source is a SQL Server, queried with a Self Hosted IR Runtime and my sink is a Datalake Gen 2,
I get the following Error
Failure happened on 'Sink' side. ErrorCode=AdlsGen2OperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=ADLS Gen2 operation failed for: Operation returned an invalid status code 'Forbidden'. Account: 'mydatalake'. FileSystem: 'temp'. Path: 'NavTemp/navcustomer.csv'. ErrorCode: 'AuthenticationFailed'. Message: 'Server failed to authenticate the request. Make sure the value of Authorization header is formed correctly including the signature.'. RequestId: '1148db6e-a01f-0069-616e-d94891000000'. TimeStamp: 'Wed, 23 Dec 2020 20:59:25 GMT'..,Source=Microsoft.DataTransfer.ClientLibrary,''Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Operation returned an invalid status code 'Forbidden',Source=,''Type=Microsoft.Azure.Storage.Data.Models.ErrorSchemaException,Message=Operation returned an invalid status code 'Forbidden',Source=Microsoft.DataTransfer.ClientLibrary,'
If I read from other Sources (using Self Hosted or Azure IR) and write to the same DataLake it works.
Could it be the Source?
Thank you so much
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 9%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
Hi @Silvano P ,
Welcome to Microsoft Q&A Platform. Thanks for posting the query.
Please suggest which authentication method is used to connect to ADLS Gen2 and if it is service principal, whether it has necessary permissions to access the particular folder in error message (please refer this document).
If issue persists, please share pipeline run id with us to assist with further investigation.
Looking forward for your response.
Hello,
thank for your reply.
I use Account Key.
What is strange is that I use this Linked Service in all my pipelines about 50 with different data sources without any issue.
I only get issues with this particular SQL Server and this integration Runtime (version 4.15.7611.1) even if I can read the tables (Preview shows no issues) but it is not able to sync to the ADLS Gen 2.
Do you have a private email where I can send you my Run Id?
Thank you so much
Hi @Silvano P ,
Sure, please share pipeline run id in mail to AzCommunity[at]microsoft[dot]com with subject - "Attn:Haritha - Error writing to Datalake Gen 2" and we will assist you further in resolving the issue.
Hi @Silvano P ,
As discussed in the mail, our product team mentioned it as a firewall issue at the ADLS folder that might have triggered the error. Please suggest if checking the same resolved the issue.
Looking forward for your response!
Hello,
Yes it was a Firewall issue!
Thank you so much for your help on this
It was a Firewall issue!
Thanks @Silvano P for confirming the same.
--
Hi @Silvano P ,
We have not received a response from you. Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members.
Hi @Silvano P ,
We still have not heard back from you. Following up to check if you can consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members.