locked
CRM 4.0 Multi-tenancy with SQL Server 2005 and 2008 RRS feed

  • Question

  • Is it possible to have a multi-tenanted instance of CRM 4.0 with different tenants using different versions of SQL Server?

    I already have single tenant using SQL 2005, for a new tenant I need in any event to use a separate SQL box, is there any reason why I could not install 2008 on the new box using the same CRM instance.
     
    • Edited by adyscaife Friday, August 7, 2009 1:03 PM Typo
    Friday, August 7, 2009 11:16 AM

Answers

  • As far as I know you can't. The MSCRM_Config database will keep all the tenants information, and the database should be located either SQL2005 or 2008 instance on the first time you install CRM. You can upgrade SQL2005 to SQL2008, the CRM will work just fine!

    Jim


    Jim Wang - MVP Dynamics CRM - http://jianwang.blogspot.com, http://mscrm.cn
    Friday, August 7, 2009 1:01 PM
    Moderator

All replies

  • As far as I know you can't. The MSCRM_Config database will keep all the tenants information, and the database should be located either SQL2005 or 2008 instance on the first time you install CRM. You can upgrade SQL2005 to SQL2008, the CRM will work just fine!

    Jim


    Jim Wang - MVP Dynamics CRM - http://jianwang.blogspot.com, http://mscrm.cn
    Friday, August 7, 2009 1:01 PM
    Moderator
  • When you create new orgs, you will be prompted for the name of the SQL Server to hold that orgs DB.  You can provide the name of a different SQL box then what is used by other orgs.  The MSCRM_Config DB is shared and will remain on the original machine, but the org DB will be placed on the other machine.

    BTW:  Not sure if different versions of SQL would work with this or not.  In theory, I don't see why it wouldn't though provided you meet the other install reqs.


    Matt, MVP - Dynamics CRM
    Friday, August 7, 2009 11:20 PM
  • Hii..

    The problem that when you choose different SQL box, The wizard will look for MSCRM_Config DB in the new SQL server before creating the Org DB; so it should be existed. 

    Saturday, August 8, 2009 9:01 AM