locked
Multiple CRM 2011 Deployments on Single SQL box with Multiple Instances RRS feed

  • Question

  • Ran in to a problem this week.

    Want to install multiple Deployments of CRM 2011 (Dev, Test and Live) using a single SQL box and multiple SQL instances. Seems simple enough until you run in to an issue with SRS and the Reporting Extensions.

    So the question is, do we have to connect to completely standalone SQL boxes or will the solution outlined in the following link work for CRM?

    http://technet.microsoft.com/en-us/library/hh389760.aspx

    Rob


    www.crmconsult.info Twitter:robertpeledie

    Thursday, June 14, 2012 10:34 AM

Answers

  • i'm guessing that Robert wants to isolate each of the instances on a seperate, standalone, CRM server for the purposes of keeping Dev and Test from impacting Live and most likely so that debugging can be done on dev.

    Another option would be to drop all the CRM Organisation databases, and Prod mscrm_config database, on a single SQL instance, but install a local sql instance on test and dev for their respective config databases.

    @Robert - what exactly is the problem you are trying to solve by splitting them up?


    http://www.oasystems.co.nz | OA Systems Ltd | CRM Solution of the Year at the Microsoft NZ 2010 Partner Awards

    Monday, June 18, 2012 11:19 PM

All replies

  • I think you can have multiple reporting services on named instances.

    you have to run the SRS data connector using the command line, which allows you to name an instance


    Ben Hosking
    Check out my CRM Blog
    Linked-In Profile
    Follow Me on Twitter!

    Thursday, June 14, 2012 8:34 PM
  • Hi Ben...

    Thanks for that, and the link from Twitter....

    I know you can have the multiple instances of both SQL and SSRS, but it seems that you cant then have multiple instances of CRM reporting extensions. After you've installed it on the SQL server and point it to the 1st instance (SQL/SSRS) you then cant seem to install another instance of it and point to another instance of SQL/SSRS.

    I cant see a way around this. It feels like MS allow you to get so far but this fails.


    www.crmconsult.info Twitter:robertpeledie

    Friday, June 15, 2012 11:37 AM
  • do you need to install SSRS on each of the instances?  Just could just point all your CRM deployments at the single, default, SSRS instance.  The SSRS doesnt need to be attached or part of the same server as the CRM SQL Databases. 

    Just make sure you dont use the same OrgName on each of your servers.... as it names the folder structure based on the org database name - instead of using the GUID (like it does in active directory groups :P)

    --

    Regan


    http://www.oasystems.co.nz | OA Systems Ltd | CRM Solution of the Year at the Microsoft NZ 2010 Partner Awards

    Monday, June 18, 2012 11:59 AM
  • You're correct that you cannot install the RS extensions on multiple instances of SSRS on the same machine.

    However, I don't see any need to have multiple SSRS instances, nor indeed multiple SQL instances (unless you want to try and allocate different physical resources - e.g. memory). In general I'd recommend using the same SQL and SSRS instance, and one CRM deployment, but with different CRM organisations for Dev, Test, Live etc


    Microsoft CRM MVP - http://mscrmuk.blogspot.com  http://www.excitation.co.uk


    Monday, June 18, 2012 1:27 PM
    Moderator
  • i'm guessing that Robert wants to isolate each of the instances on a seperate, standalone, CRM server for the purposes of keeping Dev and Test from impacting Live and most likely so that debugging can be done on dev.

    Another option would be to drop all the CRM Organisation databases, and Prod mscrm_config database, on a single SQL instance, but install a local sql instance on test and dev for their respective config databases.

    @Robert - what exactly is the problem you are trying to solve by splitting them up?


    http://www.oasystems.co.nz | OA Systems Ltd | CRM Solution of the Year at the Microsoft NZ 2010 Partner Awards

    Monday, June 18, 2012 11:19 PM