Solved

Integrate CRM 3.0 and Sharepoint 2010

Posted on 2011-03-09
4
893 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 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

All of the resources available today make learning a new digital media easier than ever-- if you know where to begin. This is a clear, simple guide to a few of the basic digital art mediums and how to begin learning them on your own.
Desired Skill Set for Microsoft Dynamics CRM Technical Resources – Part I
This Micro Tutorial will give you a introduction in two parts how to utilize Windows Live Movie Maker to its maximum capability. This will be demonstrated using Windows Live Movie Maker on Windows 7 operating system.
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.

733 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