?
Solved

Integrate CRM 3.0 and Sharepoint 2010

Posted on 2011-03-09
4
Medium Priority
?
925 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 6

Accepted Solution

by:
psv1973 earned 2000 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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Desired Skill Set for Microsoft Dynamics CRM Technical Resources – Part I
When using a search centre, I'm going to show you how to configure Sharepoint's search to only return results from the current site collection. Very useful when using Office 365 with multiple site collections.
The goal of the tutorial is to teach the user how to import photos into Adobe Lightroom efficiently and to keep everything organized.
The goal of the tutorial is to teach the user how to remove a natural vignette your photos and how to add vignette to your photos.
Suggested Courses

770 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