Solved

Integrate CRM 3.0 and Sharepoint 2010

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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

In a previous article here at Experts Exchange (http://www.experts-exchange.com/articles/18414/Create-a-PDF-file-with-Contact-Sheets-montage-of-thumbnails-for-all-JPG-files-in-a-folder-and-each-of-its-subfolders-using-an-automated-batch-method.html)…
Desired Skill Set for Microsoft Dynamics CRM Technical Resources – Part II
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
The goal of the tutorial is to teach the user how to import photos into Adobe Lightroom efficiently and to keep everything organized.

696 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