question

Aol-1065 avatar image
0 Votes"
Aol-1065 asked KranthiPakala-MSFT edited

Need help in fetching data from shared folder

Im trying to read data from shared folder to Azure SQL database using ADF. When I create linked service and do test connection in the dataset of ADF I'm getting below error. Please help me if there is any successful way to read data from shared path

"Access '\\ausdcdevdbs14.ap.cbre.net\Transfer\Research[\SG_Automate]' is not allowed on Azure integrate runtime.
Activity ID: d811bcb3-5f68-4bc3-bee8-34d3a0a7e840."

azure-data-factory
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

KranthiPakala-MSFT avatar image
1 Vote"
KranthiPakala-MSFT answered KranthiPakala-MSFT edited

Hello @Aol-1065,

Thanks for the question and using MS Q&A platform.

Could you please tell us what is the linked service being used to establish connection to your shared folder?
As a mitigation could you please try using a Self-Hosted integration runtime instead of Azure IR and see if that helps to resolve the issue?

In case if you are using File System connector, the please refer to below pre-requisites:
Ref doc: ADF File System connector - Prerequisites

203333-image.png

We look forward to your response.

Thank you



image.png (53.4 KiB)
· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Currently I'm using File share in my linked service to establish connection and the path is neither in Azure virtual network nor Amazon cloud. It is in on premises shared path for which windows authentication is sufficient. But the credentials I use for my windows login and Azure login are different. So I'm entering userid and password while creating linked service. And its giving same error as mentioned in earlier post.

"Access '\\ausdcdevdbs14.ap.cbre.net\Transfer\Research[\SG_Automate]' is not allowed on Azure integrate runtime.
Activity ID: d811bcb3-5f68-4bc3-bee8-34d3a0a7e840."

0 Votes 0 ·

It worked after creating self hosted integration runtime. Successfully connected to shared path after that. Thanks

0 Votes 0 ·

Hello @Aol-1065,

Glad to know that your issue was resolved. As I highlighted in previous comment, if your data store is located inside an on-premises network, an Azure virtual network, or Amazon Virtual Private Cloud, you need to configure a self-hosted integration runtime to connect to it.

Thanks for confirming the resolution here.

Have a nice day! :)



Thank you
Please do consider clicking on "Accept Answer" and "Upvote" on the post that helps you, as it can be beneficial to other community members.



0 Votes 0 ·