Answered

Help with Azure Data Factory and CDS

Like (0) Share

Report

Posted on 10 Aug 2020 18:18:34 by Community Power Pla...

Hey all,

I'm trying to setup a data connector in Azure Data Factory to our Common Data Service. I'm getting pretty seriously hung up on authentication unfortunately. I've been following the instructions outlined in this doc for the ADF setup and this doc for auth, but I'm getting the following error message when testing the CDS service connection in ADF:

Unable to Login to Dynamics CRM: Invalid Login Information : The HTTP request was forbidden with client authentication scheme 'Anonymous'. The HTTP request was forbidden with client authentication scheme 'Anonymous'. => The remote server returned an error: (403) Forbidden.Unable to Login to Dynamics CRM Unable to Login to Dynamics CRM The creator of this fault did not specify a Reason.

I've setup the app registration in Azure AD, setup the application user in Dynamics associated to that app, and I'm definitely using the correct service principal ID and key from the app registration. Still I'm just getting the 403 complaining about anonymous auth.

I'm using the 'Common Data Service for Apps' linked service template, but I notice there are also templates for Dynamics 365, Dynamics AX, Dynamics CRM, and a generic ODATA connector. Maybe should I be using one of those instead?

Any advice is appreciated, thanks in advance.

All responses (5)

Answers (1)

ZimDE 14 on 20 Nov 2023 at 07:28:15

Like (0)

Report

Re: Help with Azure Data Factory and CDS

@JF2022 can you share your solution? I am getting the same error...
JF2022 10 on 11 Mar 2022 at 17:22:29

Like (0)

Report

Re: Help with Azure Data Factory and CDS

I have resolved this question. Thank you for the forum and answers.
JF2022 10 on 11 Mar 2022 at 17:15:17

Like (0)

Report

Re: Help with Azure Data Factory and CDS

When you say application user can I get some detail on what that means? I am getting the same error. If using Service Principal ID as the connection, what application user needs to be added to Dynamics platform?
Verified answer

Community Power Pla... on 14 Aug 2020 at 18:23:20

Like (1)

Report

Re: Help with Azure Data Factory and CDS

Reached out to our AD admin and spent about a half our debugging this. Got it working after giving our app user the sys admin role in Dynamics. I'm guessing this was a user permission issue. I don't feel very good about leaving the user with that role, but I can at least get ADF working while I continue to tweak permissions.
trese8 Microsoft Employee on 12 Aug 2020 at 19:23:03

Like (1)

Report

Re: Help with Azure Data Factory and CDS

I would suggest to open a support case with Microsoft team.