Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics 365 | Integration, Dataverse... / Sharepoint Document In...
Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

Sharepoint Document Integration setup fails with "Failed to connect to SharePointSite"

(0) ShareShare
ReportReport
Posted on by RickardAndersson 15

Hello

Our environment looks like this 

Sharepoint 2019 (with latest patches). On-prem

CRM 9.1 Test server on-prem

CRM 9.0 Dev server on-prem

we connect the CRM 9.0 environment to one site and the 9.1 to another site in Sharepoint 2019

We use the same SSL cert (selfsigned). 

When i try to connect the 9.1 server i get this : 

<exception>Failed to connect to SharePointSite.</exception>
<errorcode>-2147088205</errorcode>

I can open the URL in the browser from the CRM sever and the site is ok. 

Both the CRM and SP are listening on HTTPS wildcard for our domain
The service user has dbo  rights in the SP Site Content DB
I have no errors when i  import the cert in CRM
I have no errors when i configure the SP side in the integration


It fells like i just cant connect at all to the SP server, Cant see anything in the ULS logs on the SP servers, Cant see anything the event viewer on CRM/SP 

Dont know where to look for errors anymore in CRM... 
I have been everywhere on Google .. 

I dont know how many times i have rebuild this integration and restarted the servers .. 
(We had a working integration to our old SP 2016 Environment) 

I have setup quite alot of these integrations, but it never worked out of the box.. 

  • RickardAndersson Profile Picture
    RickardAndersson 15 on at
    RE: Sharepoint Document Integration setup fails with "Failed to connect to SharePointSite"

    We had Microsoft troubleshoot our environment, they couldnt find the issue either.

    Im not a Dynamics/CRM expert. I had seen this solution before ( in the manual) but since i couldnt find the field in CRM and the CRM server worked with the same config in 9.0 i didnt think it would/could be this issue.

    One of the dynamics developer found the field while we were troubleshooting the issue and added the users email address to it and it just worked.

    Simple solution that took alot of hours to find.

  • Roland Hogdahl Profile Picture
    Roland Hogdahl 20 on at
    RE: Sharepoint Document Integration setup fails with "Failed to connect to SharePointSite"

    Thanks a lot for sharing, was this the suggested fix from Microsoft or did you come up with it yourself? I have seen similar scenarios with SharePoint integrations where this field had to be populated.

  • Suggested answer
    RickardAndersson Profile Picture
    RickardAndersson 15 on at
    RE: Sharepoint Document Integration setup fails with "Failed to connect to SharePointSite"

    Hello, 

    Yes we did solve this issue. 

    In CRM there is an non visable field that is "Sharepoint Email Address" This needs to contain the email adress of the user (same as field "Email Adress" ) 

    Once we populated the email adress the integration started to work. This needs to be done for all the users. 

  • Roland Hogdahl Profile Picture
    Roland Hogdahl 20 on at
    RE: Sharepoint Document Integration setup fails with "Failed to connect to SharePointSite"

    Any update on this?

    BR

    Roland

  • Roland Hogdahl Profile Picture
    Roland Hogdahl 20 on at
    RE: Sharepoint Document Integration setup fails with "Failed to connect to SharePointSite"

    Hi!

    I have exactly the same issue at a customer where i have upgraded the Test/UAT deployment/organisations to 9.1.6, they use DigiCert SHA2 wildcard certificate for the integration.

    Question is, do i open a ticket on my own or do i wait for somebody that already did to share the solution/workaround?

    Happy troubleshooting!

    =)

  • AriaConsulting Profile Picture
    AriaConsulting on at
    RE: Sharepoint Document Integration setup fails with "Failed to connect to SharePointSite"

    Rather than self-signed certs.  Ex. Verisign.

  • LioraGuez Profile Picture
    LioraGuez 10 on at
    RE: Sharepoint Document Integration setup fails with "Failed to connect to SharePointSite"

    What do you mean?

  • AriaConsulting Profile Picture
    AriaConsulting on at
    RE: Sharepoint Document Integration setup fails with "Failed to connect to SharePointSite"

    Have either of you tried commercial certs rather than self-signed?

  • LioraGuez Profile Picture
    LioraGuez 10 on at
    RE: Sharepoint Document Integration setup fails with "Failed to connect to SharePointSite"

    Do you have any news?

    I am facing the same problem

    Thks

  • Nya Profile Picture
    Nya 29,058 on at
    RE: Sharepoint Document Integration setup fails with "Failed to connect to SharePointSite"

    Thank you for the sharing.

    Best Regards,
    Nya

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,468 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Get batch job history log from D365 FO to Power Automate

Product updates

Dynamics 365 release plans