Solved

Integrate CRM 3.0 and Sharepoint 2010

Posted on 2011-03-09
4
871 Views
Last Modified: 2012-05-11
I am trying to create a SharePoint website for my company. I want to integrate my existing CRM 3.0 to the SharePoint 2010 site. I have done some research and found there are two ways to do this, one being through a dashboard and the other through webparts. I am having trouble with both options, I can't seem to link the two.

My setup...

CRM 3.0 is fully functional with its own SQL database.
SharePoint 2010 has been installed on a fresh copy of Windows Server 2008 with its own SQL Express database (Does it matter that there are two different SQL databases?). Both are on the same network and I was able to integrate SharePoint 2010 and Outlook 2010.

0
Comment
Question by:bmtservicedesk
  • 2
  • 2
4 Comments
 
LVL 6

Accepted Solution

by:
psv1973 earned 500 total points
ID: 35083484
First of all I wouldn't run SharePoint ina production environment on SQL Express, however it shoudl not affect your integration

What have you tried so far to connect the SharePoint and CRM?

Have you tried BCS?

http://msdn.microsoft.com/en-us/magazine/ee819133.aspx

0
 

Author Comment

by:bmtservicedesk
ID: 35088392
This is an excellent site which got me pretty far but when I get to "Add Connection" I was successfully able to added my SQL database which has my CRM information but then I hit the + next to tables it gives me an error "Cannot complete Refresh" - Skipping the following table because it is not configured for use: AccountBase Line 1: Incorrect systax near '('.
0
 

Author Comment

by:bmtservicedesk
ID: 35140588
When I go to "external content types" and then "Add Connection" and successfully add my SQL database (tables, views, routines), is the reason I cannot view the "table" folder because the SQL database is version 2005? Can anyone confirm this? The only folder that is viewable is "routine".
0
 
LVL 6

Expert Comment

by:psv1973
ID: 35146749
SQL 2005 or later should be fine:

http://msdn.microsoft.com/en-us/library/ee557243.aspx
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

As each individual will have his or her personal way of processing a concept and turning it into a reality, this is simply a record of my own system as a designer. It may feel daunting or even overwhelming when developing a new idea for a project…
I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
This Micro Tutorial will give you a basic overview of Windows Live Photo Gallery and show you various editing filters and touches to photos you can apply. This will be demonstrated using Windows Live Photo Gallery on Windows 7 operating system.
The goal of the tutorial is to teach the user how to edit a basic portrait of someone. This tutorial shows how to edit two basic photographs, one of a car and one of a person.

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question