Hello all,
I have been bashing my head against the wall attempting to enable Server-based integration between my D365 9.1 instance and my Sharepoint 2019 on-premises instance.
I have been using the steps based upon this link:
The error we effectively get is "Failed Authentication"
<errorlog><sites>
<site>
<url>SERVERNAME/.../CRM-dev
<exception>Failed to connect to SharePointSite.</exception>
<errorcode>-2147088205</errorcode>
</site>
</sites></errorlog>
Looking online, that error is exceptionally generic, and leads only into a circular loop where the Sharepoint Integration configuration needs to be checked.
Has anyone experienced this before or anyone who might know a way around it.
I have tried 2x different sharepoint sites with no success.
Our Dynamics 365 instance is 9.1.4.31 (september 2021).
Please advise.
That's good news.
As I believe you can mark multiple post as answered I'd would be grateful if you did so.
Best regards.
Philip
Thank you for your suggestion Philip, that was perfect.
I needed to edit the user profile manually.
The Sharepoint Site collection is now validated and we can move into config steps.
Thank you again to both yourself and Venkatesh, greatly appreciated.
Jayden.
Hi Jayden.
As you are now getting a 401 Unauthorized I would check that the user(s) have the Email field populated in SharePoint Central Admin- Service Applications - User Profile Service Application - User Profile that the value matches the one set in the SharePoint Email address in CRM.
This is done either by User Profile sync with AD(assuming the user object has the email address that matches) or by editing the User Profile manually.
Best regards.
Philip
Hi,
Great, If this helped you, I'd appreciate it if you'd mark this as a Verified Answer, which may in turn help others as well.
Regards,
Venkatesh N
Hi Venkatesh,
Your suggestion is spot on, I apologise as it something I have likely overlooked in my workings.
The error has progressed now to "Failed Authorization" Error (401).
I will tackle this issue now and report back.
Thanks,
Jayden.
Hi,
Check the user have the Sharepoint Email Address value populated on the User form.
This is publicly documented here:
Hope this helps!
Regards,
Venkatesh N
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,240 Super User 2024 Season 2
Martin Dráb 230,104 Most Valuable Professional
nmaenpaa 101,156