CODEWITHSUNDEEP
sqlconnectionfirewallaclazure-data-factory
RAH
RAH

Reputation: 13

Data Factory New Linked Service connection failure ACL and firewall rule

I'm trying to move data from a datalake stored in Azure Data Lake Storage Gen1 to a table in an Azure SQL database. In Data Factory "new Linked Service" when I test the connection I get a "connection failed" error message, "Access denied...make sure ACL and firewall rule is correctly configured in the Azure Data Lake Store account. I tried numerous times to correct using related Stack overflow comments and plethora of fragmented Azure documentation to no avail. Am I using the correct approach and if so how do I fix the issue?

Upvotes: 0

Views: 1717

Answers (1)

Steve Johnson
Steve Johnson

Reputation: 8660

Please follow me:

First:

Go to ADF and new Linked service in ADF,then copy Managed identity object ID. storage

Second:Go to Azure Data Lake Storage Gen1,navigate to Data Explorer -> Access -> click select in the 'Select User or group' field.

Finally:paste your Managed identity object ID and then test your connection in ADF. access

Upvotes: 2

Related Questions