CRM 2011 - Multiple Application Servers and One SQL Server with Single Organisation (not load balancing)
Category: dynamics crm deployment
Stanley_Lai on Wed, 26 Feb 2014 11:15:27
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.
Jason J Peterson on Wed, 26 Feb 2014 13:15:18
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 J Peterson on Mon, 03 Mar 2014 16:56:34
Did this info help? If so, can you mark it as answered?
VanderMental on Mon, 09 May 2016 19:51:17
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.