error :The HTTP request was forbidden with client authentication scheme 'Anonymous'. in linked service

Question

while connecting to dynamics 365 in data factory .i'm getting the below error .
i have provided the client id and scerect to get connected in linked service.

kindly check if i'm missing anthing here
Error :
Failed to connect to Dynamics: 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

Answer 1

Hello @Josh ,

Thanks for the question and using MS Q&A platform.

From the error message (Failed to connect to Dynamics: Unable to Login to Dynamics CRM: Invalid Login Information) my understanding is that authentication is failing.
Could you please confirm what authentication type is being used in your linked service?

I suspect something wrong with your authentication settings/configurations.

1. If you are using Azure AD service-principal authentication, you must set up server-to-server (S2S) authentication in Dataverse or Dynamics. First register the application user (Service Principal) in Azure Active Directory. You can find out how to do this here. During application registration you will need to create that user in Dataverse or Dynamics and grant permissions. Those permissions can either be granted directly or indirectly by adding the application user to a team which has been granted permissions in Dataverse or Dynamics. You can find more information on how to set up an application user to authenticate with Dataverse here.
2. In case if you are using Office 365 Authentication type, please note if your tenant and user is configured in Azure Active Directory for conditional access and/or Multi-Factor Authentication is required, you will not be able to use `Office 365 Authentication type. For those situations, you must use an Azure Active Directory (Azure AD) service principal authentication.

I would recommend reviewing the prerequisites section from the connector documentations: ADF Dynamics 365 connector - Prerequisites

Helpful document: This article will show step-by-step information about creating an application user: Manage application users in the Power Platform admin center

Hope this will help. Please let us know if any further queries.

------------------------------

• Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
• If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators

Answer 2

Hi Josh,
I am facing the same issue can you please help me to resolve this issue.

Thanks!