Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

Authorization failure on sharepoint online integration to Dynamics 365 online

Posted on by Microsoft Employee

I have configured this for a week and still no solution on this authorization error.

I have 3 users, one user have O365 roles Service Administrator, User management Administrator, Sharepoint Administrator, and the other 2 user only has role Sharepoint administrator.

I have setup the Dynamics 365 role to system administrator for all of them, and set as owner in sharepoint online, but I still got below error for user who only has role sharepoint administrator. For first user who have 3 roles, is able to upload file to sharepoint online.

"Exception occured while accessing SharePoint: Unhandled Exception: System.Net.WebException: The remote server returned an error: (401) Unauthorized."

Do anyone have experience on setup this integration ? I guess service administrator and user management administrator have no correlation to sharepoint online. I also have filled in the sharepoint email address on systemuser for all of them.

Thanks

Best Regards,

Afin

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Authorization failure on sharepoint online integration to Dynamics 365 online

    any updates on that? above link isn't working. i have crm 2016 on prem, followed steps from docs to integrate it with sharepoint online and still getting 401 unauthorized error while connecting.

  • Suggested answer
    M.T. Eikelenboom Profile Picture
    M.T. Eikelenboom 5,241 on at
    RE: Authorization failure on sharepoint online integration to Dynamics 365 online

    To setup server side integration between CRM and SharePoint online, you need to be a global admin in Office 365. Otherwise it will not work.

  • Johnny Gong Profile Picture
    Johnny Gong 6,482 on at
    RE: Authorization failure on sharepoint online integration to Dynamics 365 online

    Hi,

    Once I collect an article about Unauthorized issue occurred in D365 OL Server-Based SharePoint Integration. The following linkage could be your reference.

    https://partnersupport.microsoft.com/en-us/par_onlserv/forum/par_dyn365on/top-issue-server-based-sharepoint-integration/c1d949a4-716c-4212-a577-38805cadaf0b

    heheda.PNG

    Please mark my answer as verified if you found it helpful. This way the community can see there is a valid answer to the thread's topic.

    Regards 

    Johnny

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans