web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Server-Based SharePoin...
Microsoft Dynamics CRM (Archived)

Server-Based SharePoint Integration: "Unauthorized"

(0) ShareShare
ReportReport
Posted on by Joe Woltering 12,163

Trying to integrate Dynamics 365 (On-Prem) with SharePoint 2013 (On-Prem). As far as I can tell I've followed the documentation to a tee and was able to issue all the powershell commands without error. But once I get to the point of actually running through the Integration wizard I receive a 'Failed Authentication' error and in the resulting Error Log it just says "The remote server returned an error: (401) Unauthorized."

I enabled trace on the CRM side and the only thing I can locate in the log is that same error without any additional info and the SharePoint ULS logs yield no valuable information either.

How can I troubleshoot this?

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Radu Chiribelea Profile Picture
    Radu Chiribelea 6,667 on at

    Hi Joe,

    I think there was a field on the System User entity, called sharepointemailaddress. If not already added, can you please add that to the User Form and make sure that it filled in, with data for the user, with whom you are running the integration wizard?

    This needs to be filled in with the exact same email address, that appears in SharePoint for this user.

    Then, please try to do the integration again.

    Hope this helps.

    Radu

  • Joe Woltering Profile Picture
    Joe Woltering 12,163 on at

    Hi Radu,

    Yes, I've tried adding that field to the from and populating with the same email address as the person running the integration, which in this case, is myself. No joy unfortunately.

  • Radu Chiribelea Profile Picture
    Radu Chiribelea 6,667 on at

    Hi Joe,

    Are the SPNs configured correctly?

  • Joe Woltering Profile Picture
    Joe Woltering 12,163 on at

    I think I've traced the issue to the User Profile Sync service not starting in SP 2013 due to an issue with SQL 2014 which apparently was addressed in the June 2014 CU. Will apply over the weekend and discover the results. 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans