Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
CRM 2011 - Multiple Application Servers and One SQL Server with Single Organisation (not load balancing) RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi all,

    I have multiple app servers setup - App1, App2, App3, etc

    I have one sql server containing a single database with 1 Org - XXXX_MSCRM

    Can I install each app server with CRM and then use the deployment manager to point to the single SQL server and database?

    Will this work at all?

    I know that there will be issues with SSRS reporting but what else?

    Please note that I will NOT intend to be setting up load balancing.

    Thanks,

    Stanley

    Wednesday, February 26, 2014 11:15 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    The deployment manager settings and information come from the config database.  Therefore, which ever of the 3 app servers you were to bring up the deployment manager in, it would show the same information.

    The first CRM server you install to will be a new installation and create a new config database and org database as well as create the AD security groups.

    Any CRM servers installed after that will be installed with the option install to existing databases (because everything is already there).

    All 3 app servers will use the same SSRS server since they all point to the same config database.

    However, if your intention is to have each app server to be point to different organizations, then the databases need to be on named instances, with each app server installing to its own named instance.  Again, because each would need to have their own config databases and they cannot coexist on the same SQL instance.  At that point, each named instance/config database will need to point to its own SSRS server.

    Jason Peterson

    • Proposed as answer by Jason J Peterson Monday, March 3, 2014 4:56 PM
    • Marked as answer by Stanley_Lai Tuesday, September 23, 2014 4:58 AM
    Wednesday, February 26, 2014 1:15 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    The deployment manager settings and information come from the config database.  Therefore, which ever of the 3 app servers you were to bring up the deployment manager in, it would show the same information.

    The first CRM server you install to will be a new installation and create a new config database and org database as well as create the AD security groups.

    Any CRM servers installed after that will be installed with the option install to existing databases (because everything is already there).

    All 3 app servers will use the same SSRS server since they all point to the same config database.

    However, if your intention is to have each app server to be point to different organizations, then the databases need to be on named instances, with each app server installing to its own named instance.  Again, because each would need to have their own config databases and they cannot coexist on the same SQL instance.  At that point, each named instance/config database will need to point to its own SSRS server.

    Jason Peterson

    • Proposed as answer by Jason J Peterson Monday, March 3, 2014 4:56 PM
    • Marked as answer by Stanley_Lai Tuesday, September 23, 2014 4:58 AM
    Wednesday, February 26, 2014 1:15 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Did this info help?  If so, can you mark it as answered?

    Jason Peterson

    Monday, March 3, 2014 4:56 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Jason/Stanley<o:p></o:p>

    I'm sitting in the same/similar predicament, I'd like to rebuild our App Server. We currently have 6 Orgs on one SQL using one App Server 2008 R2. We’d like to upgrade this environment, starting with the App Server(Server 2012).

    I was going to Install the CRM on the new server(Create a Temp Org) once I was happy with the install, I’d want to change the server to allow for testing/access to the Live orgs through the new server(While the Old App Server is still being used), prior to shutting it down.

    What issues, possible gotchas should I be aware of?

    Thank in-advance for your assistance in this regard.

    Leonard


    Monday, May 9, 2016 7:51 PM