locked
can sharepoint 2010 and MS Dynamics CRM 2011 share the same sql server reporting service? RRS feed

  • Question

  • I would like SharePoint and SQL Server installed as Integration mode. In that case, is it still OK to configure/install MS Dynamics CRM 2011 to use that reporting services?

    Thanks,

    Monday, May 14, 2012 7:15 PM

Answers

  • That's correct Guangming. Unfortunately the Sharepoint integration mode doesn't work well in CRM. I'm afraid you will need another license.

    Or if you find third party solutions that use reporting in a different way, you could possibly make use of the native mode and at the same time deploy reports, and save money.


    Visit my blog for CRM material, improving performance, kerberos, IFD, development tips, etc. :) http://quantusdynamics.blogspot.com

    • Marked as answer by Guangming Thursday, May 17, 2012 2:54 PM
    Monday, May 14, 2012 9:02 PM
    Answerer

All replies

  • Hi,

    Yes, SharePoint and CRM 2011 can share the same SQL Server and same Reporting Server services.

    Probably the biggest benefit of running Reporting Services in SharePoint Integrated Mode is that you can deploy and manage reports directly in SharePoint rather than the Report Manager web application.  This is probably easier for our business users.  As a matter of fact you no longer use the Report Manager after you switch to SharePoint Integrated Mode.

    I advise to have a separate setup of Reporting services for your CRM 2011 needs as you most probably would need it dedicated to CRM 2011. Being resources intensive and business applications, SharePoint and CRM 2011 main benefits are in its rich reporting features. So always better to have its own dedicated reporting environment.

    I hope this helps. If my response answered your question, please mark the response as an answer and also vote as helpful.


    Ashish Mahajan, CRM Developer, CSG (Melbourne)
    My Personal Website: http://www.ashishmahajan.com
    My Blogs: http://ashishmahajancrm.blogspot.com.au and http://ashishmahajancrm.wordpress.com
    My Youtube Channel: http://www.youtube.com/user/ashishmahajanmscrm

    My Linkedin: View Ashish Mahajan's profile on LinkedIn
    My Twitter: https://twitter.com/#!/ashishmahajan74

    Monday, May 14, 2012 8:07 PM
  • Hi Guangming,

    I think your questions depends how you will use reports within sharepoint. CRM is not compatible with sharepoint integrated mode, however you can possibly integrate different applications  (webparts) in sharepoint if they use SRS native mode functionality.

    You need to use native mode for CRM otherwise will not work, and for sharepoint depends on what you are deploying in order to make use of SRS in native mode within Sharepoint.

    Hope it helps.


    Visit my blog for CRM material, improving performance, kerberos, IFD, development tips, etc. :) http://quantusdynamics.blogspot.com


    Monday, May 14, 2012 8:08 PM
    Answerer
  • I do want the benefits of sharepoint and sql server reporting services in integration mode as Ashish indicates.

    what you are saying is that in the sharepoint and sql rs integration mode, I can not use the rs for CRM. Is it correct? If so, it is so bad - I have to buy one more license!?

    Monday, May 14, 2012 8:31 PM
  • That's correct Guangming. Unfortunately the Sharepoint integration mode doesn't work well in CRM. I'm afraid you will need another license.

    Or if you find third party solutions that use reporting in a different way, you could possibly make use of the native mode and at the same time deploy reports, and save money.


    Visit my blog for CRM material, improving performance, kerberos, IFD, development tips, etc. :) http://quantusdynamics.blogspot.com

    • Marked as answer by Guangming Thursday, May 17, 2012 2:54 PM
    Monday, May 14, 2012 9:02 PM
    Answerer