Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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,159

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

  • Joe Woltering Profile Picture
    Joe Woltering 12,159 on at
    RE: Server-Based SharePoint Integration: "Unauthorized"

    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. 

  • Radu Chiribelea Profile Picture
    Radu Chiribelea 6,667 on at
    RE: Server-Based SharePoint Integration: "Unauthorized"

    Hi Joe,

    Are the SPNs configured correctly?

  • Joe Woltering Profile Picture
    Joe Woltering 12,159 on at
    RE: Server-Based SharePoint Integration: "Unauthorized"

    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.

  • Suggested answer
    Radu Chiribelea Profile Picture
    Radu Chiribelea 6,667 on at
    RE: Server-Based SharePoint Integration: "Unauthorized"

    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

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans