Recently I was working with a client to configure the out of the box integration between Dynamics CRM and SharePoint. In the client’s case, they were using CRM 2013 Online via Office 365, and SharePoint 2010 on-premise.
When integrating CRM and SharePoint for document management, out of the box you now have two main options:
Let’s briefly look at each, then we’ll get to our issue. If you can’t wait then feel free to jump ahead. Perhaps in another blog we’ll dive deeper into how to configure the integration and the different methods but for now we’ll take a fly by. There’s a good comparison of the differences between the two here on TechNet:
This feature was introduced in the Dynamics CRM Online Spring ‘14 Wave and is only available when using both CRM and SharePoint Online via Office 365. Unlike the CRM list component that is client-based, this feature is server-based and does not require any installation of any solutions. Use the following steps to enable server-based integration from TechNet:
It’s documented more here in this video from Microsoft:
The CRM list component is a free download from Microsoft as a Microsoft sandboxed-solution (client-side). You upload this to the SharePoint site collection, then configure CRM. The CRM list component provides more of the standard features of a SharePoint document library from the CRM form like versioning, check in / check out, alerts, etc. When users attempt to open the Documents section in CRM for an entity, they will be required to login before the content is rendered.
Per Microsoft, this methodology is being deprecated but it still an option for SharePoint 2010 and SharePoint 2013. To install and configure the CRM list component, follow these steps from TechNet:
So this brings us to the issue at hand. After getting SharePoint available on the public interweb and thus available to CRM, we installed and activated the list component. For a short while, everything seemed fine. A little time passed before we were able to configure the CRM entities that we wanted to map, so we did that and finalized the configurations in CRM. It found SharePoint as a valid URL, all was good (or so I thought). When we went to an Opportunity or other entity that was configured for document management, it would throw an error along the lines of:
“An error occurred while loading the page. The URL may not have been mapped in the SharePoint Server. Ask your system administrator to check the Configure alternate access mappings settings in SharePoint Central Administration.”
Back over in SharePoint, I knew that the CRM list component is based on the sandboxed service, I tried to de-activate and re-activate the site collection feature. I got this:
We restarted the SharePoint 2010 User Code Host Windows service, which threw login errors. After re-typing the password, it stuck. Everything was ok again for 5 minutes. Another step was to add just the user who was running the SharePoint 2010 User Code Host service in the local group Performance Log Users group. This seemed to help the login issue, but granting that user the login as a service right is what ultimately fixed that. Also make sure that on your Web Application, Browser File Handing is set to Permissive. Once past that, I was still getting errors. I watched the ULS, and noticed this:
NOW we have something to work with. To fix this, we need grant some permissions on the SQL stored procedure.
Restart the SharePoint 2010 User Code Host service for good measure, and make sure that the List Component solution is activated, and the site collection feature is activated. To be sure, you should be able to de-activate it, and re-activate it. It should work without error now. Go back to CRM and attempt to load the Documents view. You should get success!
One other possible error you might see that I saw from a lot of folks is documented here on MSDN. Pay attention to the error message, as this relates to a refused error. Good luck!
The complementary paper includes over 12 years of research, recent survey results, and CRM turnaround success stories.
This 60-second assessment is designed to evaluate your organization's collaboration readiness.
Learn how you rank compared to organizations typically in years 1 to 5 of implementation - and which areas to focus on to improve.
This is a sandbox solution which can be activated per site collection to allow you to easily collect feedback from users into a custom Feedback list.
Whether you are upgrading to SharePoint Online, 2010, 2013 or the latest 2016, this checklist contains everything you need to know for a successful transition.