SharePoint 2010 and CRM 2011 Integration
References and Credits:
Download the CRM 2011 List component for SharePoint 2010 solution from here.
Extraction of the folder will reveal the following items
Open Central Administration and click on Application Management. Then Browse to Web Applications and this will open the web applications currently installed on SharePoint. Highlight the web application that will host the Site Collection to be integrated with CRM as shown below. On the ribbon the icon for General Settings will no longer be greyed out as shown below
Under the Web Applications general settings window that has now opened, browse to the end of the window to the section containing Browser File Handling permissions and click on “Permissive”.
Open your site collection and under site actions, click on Site Settings.
Select Solutions from the Gallery and the following window called Solutions gallery will pop open. Choose upload and browse to the folder that contains the extracted files from step 2
Press upload and the following box will pop up. “CLICK CLOSE”
At this stage, the solution has been uploaded onto the Site Collection properly. The CRM list component requires Microsoft SharePoint Foundation Code Service to be running before you can activate the solution.
For the sake of example, I used Search Server Express 2010 with a SQL 2008 R2 DB server.
The following services were started in order during the installation of SharePoint,
- State Service
- Usage and Health Service
- Search Foundation Search
- Search Service
- Sandbox Solution Service – Foundation Code Service
- Web Analytics Service
So to continue with the CRM integration post,
Before activating the solution, verify that the appropriate service is running
Open either PowerShell or SharePoint Management Shell and browse to the folder that contains the extracted files. Within this folder is a PowerShell file called AllowHtcExtn.ps1. The execution of this file is only necessary if SharePoint is installed on a Domain Controller, for example in a development environment. But I have also found if the VM that has SharePoint installed on it, was previously a domain controller and was “dcpromed” , then run the script. There is no harm in running the script even if you are not sure.
Remember to add the URL – http://servername at the end as shown
Head back to the site collection and open Solution Gallery under Site Settings again. Click Activate this time , to activate the solution,
Within a few seconds, the solution will display activated as shown
Open CRM and under Settings , click on Document Management,
- Solution not activating :-
- Installation of SharePoint has been corrupted for some reason.
- Running of the AllowHtcExtn.ps1 Script wasn’t done with the proper arguments.
- Didn’t add the Brower File Handling permission for the Web Application.
- CRM keeps complaining the List Component is not activated even though the site is valid URL
- Try adding the site to the Trusted Intranet page
Permission to the site for the CRM user. Provide the user with Design Permissions.