Need help in fetching data from shared folder

Aol 1

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."

1 answer

KranthiPakala-MSFT 46,422 Reputation points Microsoft Employee

2022-05-18T23:21:09.95+00:00

Hello @Aol ,

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

We look forward to your response.

Thank you
Please sign in to rate this answer.

1 person found this answer helpful.
Aol 1 Reputation point

2022-05-19T03:45:54.33+00:00

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."

Aol 1 Reputation point

2022-05-20T12:39:09.183+00:00

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

KranthiPakala-MSFT 46,422 Reputation points Microsoft Employee

2022-05-20T23:15:35.643+00:00

Hello @Aol ,

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.
Sign in to comment