数据工厂新的链接服务连接失败ACL和防火墙规则 [英] Data Factory New Linked Service connection failure ACL and firewall rule

问题描述

我正在尝试将数据从存储在Azure Data Lake Storage Gen1中的数据湖移到Azure SQL数据库中的表.在测试连接的数据工厂新链接服务"中，出现连接失败"错误消息，访问被拒绝...请确保在Azure Data Lake Store帐户中正确配置了ACL和防火墙规则.我尝试了很多次纠正相关的堆栈溢出注释和过多的零碎的Azure文档无效.我使用的是正确的方法吗?如果可以，如何解决此问题?

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?

推荐答案

请关注我:

第一:

转到ADF和ADF中的新链接服务，然后复制Managed identity object ID.

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

第二:转到Azure Data Lake Storage Gen1，导航到Data Explorer-> Access->单击选择用户或组"字段中的选择.

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

最后:粘贴您的Managed identity object ID，然后在ADF中测试您的连接.

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

这篇关于数据工厂新的链接服务连接失败ACL和防火墙规则的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！