locked
SSRS on CRM Server and one SQL server for multiple deployment RRS feed

  • Question

  • We would like to have following topology for our dev and QA environment.
    The implementation requires Internet Facing Deployment (IFD).

    Server 1: DEV server:  MSCRM 4.0, SSRS and SSRS Connector

    Server 2: QA Server:  MSCRM 4.0, SSRS and SSRS Connector

    Server 3: DB Server: (One db server would have separate named instance database for DEV and QA as below.)
     DEV DB:  CRMDB\DEV
     QA DB:   CRMDB\QA 


    Production DB server will have only one database instance.

    I assume that I need to have SSRS Connector due to IFD implemenation (please clarify otherwise).  Also, the DEV and QA server will be in our DMZ (service network) network and will open up the required ports to connect the DB server.

    Please let me know your suggestion and greatly appreciate your answers for the following questions.


    1.  Is it possible to install SSRS on a machine which does not have SQL server?
    2.  Is it good practice to install SSRS and MSCRM on the same machine?
    3.  Does this topology has any impact on performance, security and etc?

    Tuesday, September 22, 2009 8:39 PM

Answers

  • HI

    1.  Is it possible to install SSRS on a machine which does not have SQL server?
    yes it is
    2.  Is it good practice to install SSRS and MSCRM on the same machine?
    I always try to stay away from the SSRS connector,just something else that might cause problems.:)
    3.  Does this topology has any impact on performance, security and etc?
    Yes is does depending on your implementation,db size etc.

    http://technet.microsoft.com/en-us/magazine/2009.02.crm.aspx
    Tiaan van Niekerk http://crmdelacreme.blogspot.com Skype:tiaan.van.niekerk1
    Wednesday, September 23, 2009 3:40 AM

All replies

  • HI

    1.  Is it possible to install SSRS on a machine which does not have SQL server?
    yes it is
    2.  Is it good practice to install SSRS and MSCRM on the same machine?
    I always try to stay away from the SSRS connector,just something else that might cause problems.:)
    3.  Does this topology has any impact on performance, security and etc?
    Yes is does depending on your implementation,db size etc.

    http://technet.microsoft.com/en-us/magazine/2009.02.crm.aspx
    Tiaan van Niekerk http://crmdelacreme.blogspot.com Skype:tiaan.van.niekerk1
    Wednesday, September 23, 2009 3:40 AM
  • Hi Tiaan,

    Thank you so much for your answer.  Based on the article you provided, we may follow the setup as indicated in figure 5.  But it is not exactly same, since one SQL server holds multiple instance databases and each one corresponding to different environment.    Can you please tell me whether this approach would casuse any issue with custom solution code?  We are anticipating some custom code involvement in our implementation. 

    Also, the author did not recommend the approach of figure 5 as it is "hybird hack" at best.  Can you please provide more information on this?

    Thanks in advance,
    Sudhagar
    Thursday, September 24, 2009 1:18 PM