locked
Multiple CRM Installations Using the Same SRS Server RRS feed

  • Question

  • Hey,

    My client is currently building out multiple CRM Application server environments for federal agencies. We have a clustered SQL server to handle the backend servers, but we want to use the same instance of SRS for multiple CRM instances. These would not be multiple tenants within the same CRM instance (though we will have multi-tenancy for each agency), but separate CRM installations, each with a dedicated application server, utilizing the same SRS Instance.

    Is this possible? If not, could we possibly have multiple instances of SQL Server 2008 on the same machine, each with it's own SRS instance?


    --Dodd
    Tuesday, July 26, 2011 7:49 PM

Answers

All replies

  • Hi,

    Yes, its possible, you can install (seperate) multiple CRM installations for Single SSRS instance. It would not effect.

    Please follow the normal CRM installation steps. when the installation done, apply the latest CRM Rollup update(s) on SRS server and CRM server as instructed.

     


    Thanks, - Israel Pradeep, - Software Engineer & PMP & B.I - Entrepreneur, - "If this post answers your question, please click "Mark As Answer" on the post and "Mark as Helpful"".
    Wednesday, July 27, 2011 12:12 AM
  • Though I have never tried to use shared Reporting Services for different CRM deployments, I believe it's very likely possible to do so. 

    However, it's NOT recommended even this may be possible. The reason is, when the two deployments (or environments) both have a CRM organization of the same name, you are going to have trouble. 

    Quote from CRM Planning Guide document:

    Separate deployments of Microsoft Dynamics CRM cannot share one SQL Server Reporting Services server. However, a single deployment of Microsoft Dynamics CRM that has multiple organizations can use the same SQL Server Reporting Services server

    Hope this helps.

    Cheers,


    Daniel Cai | http://danielcai.blogspot.com

    Wednesday, July 27, 2011 3:33 AM
  • Hello,

    We never had any luck doing this - we opted for multiple SRS instance, but couldn't get it working due to the Dynamics SRS Data Connector.

    See this other thread which discusses a similar question - http://social.microsoft.com/Forums/en/crm/thread/ea93c5d2-9b4d-4ecc-8d97-e1f1276d88e1

    We tried following this approach

    http://www.davidtruxall.com/blog/2010/12/02/ConfiguringCRM40ForSSRSWithoutTheDataConnector.aspx

    to see if we could get around it for CRM 2011 in the end we gave up and placed an SRS instance on the application servers, but pointed the SRS database back to the SQL instances. 

    Good luck.
    Glenn

    • Marked as answer by MDodd73 Wednesday, July 27, 2011 3:45 PM
    Wednesday, July 27, 2011 4:05 AM
  • Thanks. In this case, we will not have any overlap in terms of Organization names. Though it would seem the planning guides explicitly says this cannot be done, if the only reason is because duplicate Org names would mess things up, I think we might be okay.

    Though I may probably advise against it anyway, just to be safe.


    --Dodd
    Wednesday, July 27, 2011 1:27 PM
  • in the end we gave up and placed an SRS instance on the application servers, but pointed the SRS database back to the SQL instances.


    Could you explain you approach again? I tend to get confused when it comes to multiple deployments and SQL instances. In your case are you saying:

    1. You have multiple CRM deployments.
    2. You have multiple SQL Instances on a single Server
    3. You have SSRS installed on each CRM Application server

    And what would be the answer to the second question in my original post, having multiple instances of SQL on the same server, each with their own instance of SRS? Would this be a better solution?


    --Dodd
    Wednesday, July 27, 2011 1:39 PM
  • I don't think duplciate OrgNames is the fundamental problem; rather it's that CRM SRS Data Connector can only support one CRM deployment - i.e. it will only connect to one given MSCRM_Config database. As far as I know this configuration is per SRS server, and installing mulitple instances of SRS on the one server won't help.
    Microsoft CRM MVP - http://mscrmuk.blogspot.com  http://www.excitation.co.uk
    • Marked as answer by MDodd73 Wednesday, July 27, 2011 3:44 PM
    Wednesday, July 27, 2011 3:35 PM
    Moderator
  • Got it. I surmised as much after I read the other posts from the link above. We made the recommendation for separate SRS servers for each CRM App server.
    --Dodd
    Wednesday, July 27, 2011 3:44 PM