question

SupplyChainGlass-6584 avatar image
0 Votes"
SupplyChainGlass-6584 asked SaurabhSharma-msft commented

Linked Service with ADF Connection Failing

I am attempting to connect by Azure Data Lake Analytics account with Azure Data Factory via a Linked Service. I have added the required information in the Edit linked service blade, created an app and a secret for the Service Principal ID and key, set up the API permissions, added the role assignment of Data Lake Analytics Developer to the credentials I am using, and used the Add User Wizard to give the credentials I am using the Data Lake Analytics Developer role and assign read and write permissions. When I test the connection in my linked service I get the message: "User is not authorized to data lake analytics."

These are the two tutorials I followed to create this linked service:
https://pedrosancheznaranjo.com/conectando-azure-datalake-analytics-a-azure-datafactory-con-un-linked-service-y-service-principal
https://www.mssqltips.com/sqlservertip/5930/create-azure-data-lake-linked-service-using-azure-data-factory/

I cannot find any information on what I may have done incorrectly to get the error message "User is not authorized to data lake analytics."

azure-data-factoryazure-data-lake-analytics
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

SaurabhSharma-msft avatar image
0 Votes"
SaurabhSharma-msft answered SaurabhSharma-msft commented

@SupplyChainGlass-6584 You need to add role assignment of Data Lake Analytics Developer to you registered application/service principal instead of user credentials you are using. While adding the role assignment you can search your application on Select search box and then select your application (See screenshot below).
36923-image.png
Once added you can validate your connection by going to your ADF instance. (See screenshot below)
36884-image.png

Please let me know if you still see any issues.


Please do not forget to "Accept the answer" wherever the information provided helps you to help others in the community.


image.png (16.8 KiB)
image.png (55.4 KiB)
· 2
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.

@SupplyChainGlass-6584 Please let me know if you still have any issues.

0 Votes 0 ·

@SupplyChainGlass-6584 I am following up to know if you are still facing this issue. Please let us know so that we can help resolve your issue.

0 Votes 0 ·