Multiple dev environments of CRM 2011 on one SQL 2012 server RRS feed

  • Question

  • Hello,

    I have requirement to install multiple development servers of CRM 2011 which would use one SQL 2012 Server. 

    As you know, you need separate CRM 2011 Reporting Extensions, which means that Reporting Services (SSRS) should be installed not in SQL 2012 server but in the same server as CRM 2011. For SSRS (on CRM 2011 server) I want to use SQL 2008R2 Express (licensing issues).

    Is it possible to use SQL 2008R2 Express only for SSRS, while CRM 2011 is using SQL 2012 on different server?

    I get errors while creating organization:

    System.Web.Services.Protocols.SoapException: The feature: "Customizing security roles" is not supported in this edition of Reporting Services.

    Environment information:

    CRM 2011 on Windows Server 2008 R2. In the same server SSRS 2008 R2 on SQL 2008 R2 Express

    CRM database in different machine with SQL 2012 on Windows Server 2012.


    Thursday, January 29, 2015 9:50 AM

All replies

  • SQL Express is not supported for Dynamics CRM.  Plus, the only way to have completely separate installations of Dynamics CRM pointing to one server for SQL is to used named instances of SQL Server on the Windows server you're installing SQL.  So you literally would have to install SQL multiple times on that one box.

    Instead of going through all that effort, why not just install Dynamics CRM once, and then make multiple CRM deployments using the CRM Deployment Manager? You can make as many CRM environments as you need with a single install of Dynamics CRM. This works great in dev environments where you need multiple instances for multiple devs. Plus, it gives you exactly one point of administration when it comes to the CRM install, and is a lot more supportable.

    The postings on this site are solely my own and do not represent or constitute Hitachi Solutions' positions, views, strategies or opinions.

    • Proposed as answer by Wayne Walton Thursday, January 29, 2015 1:35 PM
    Thursday, January 29, 2015 1:35 PM