locked
2 CRM servers one SQL database question / problem RRS feed

  • Question

  • Hi all.

    We have a client with two CRM 3.0 servers on the same domain, is it possible that both servers use / point to the same database, and if so how should we go about setting it up?
    Friday, April 3, 2009 8:22 AM

Answers

  • Hi Danny,

    In 3.0 it was not possible to have more then one CRM instance (org. name) in one domain, but you could have multiple CRM solutions using the same SQL Server. So in your example, the two organzations must be in different domains?

    As I understand this case, it's a case where "Ghostpop" have 2 CRM servers to improve performance; while they are both for the same CRM instance (organization). This is typically a topic for global organizations that do this to manage the challange of Latency.

    Morten
    • Marked as answer by Jim Glass Jr Friday, April 3, 2009 3:51 PM
    Friday, April 3, 2009 2:14 PM

All replies

  • Hi,

    It's possible.

    You can read more about it in the implementation guide.

    I recommend that you download this one for further reading: http://www.microsoft.com/downloads/details.aspx?familyid=1ff067f8-4f77-40f0-ae9c-68ada7d4f16a&displaylang=en

    and here: http://www.microsoft.com/dynamics/crm/using/deploy/clusteringmscrmservers.mspx 

    Morten
    Friday, April 3, 2009 8:27 AM
  • Hello,

    Yes it is possible and part of the beauty of CRM!  When setting up your installation, just point to the same server, and when you configure the organization name, it will create a seperate database on the same server (as long as you point to the same server). 

    For example, if your first CRM 3.0 installation is configured with an organization name of "CroweHorwathOne", it will create a database with a name something to the effect of "CroweHorwathOne_MSCRM," and then for your second install, the org name is "CroweHorwathTwo," then the second database created will be named "CroweHorwathTwo_MSCRM."

    Just be sure the SQL Server has enough processing power, and memory to handle all this =).  Good luck!
    Danny Varghese - Crowe Horwath LLP - http://www.crowehorwath.com/cs/blogs/crm
    Friday, April 3, 2009 2:03 PM
  • Hi Danny,

    In 3.0 it was not possible to have more then one CRM instance (org. name) in one domain, but you could have multiple CRM solutions using the same SQL Server. So in your example, the two organzations must be in different domains?

    As I understand this case, it's a case where "Ghostpop" have 2 CRM servers to improve performance; while they are both for the same CRM instance (organization). This is typically a topic for global organizations that do this to manage the challange of Latency.

    Morten
    • Marked as answer by Jim Glass Jr Friday, April 3, 2009 3:51 PM
    Friday, April 3, 2009 2:14 PM