locked
Installing 2011 - SQL server in different domain RRS feed

  • Question

  • Hello All,

    I have a client who is in the process of migrating from an old domain structure to a brand new domain. They are looking to install CRM 2011 onto their new domain, at least for the web server part. Their issue at the moment is that their SQL server cluster is in the old domain & won't be migrated for some time. There is a trust relationship between the two domains.

    Question: Can we install CRM onto servers in different domains for the web application & the database? My gut feeling is that this is going to cause some grief, but I can't see any documentation on this either way.

    Regards,

    Paul


    Paul Dowman, CRM Developer
    Tuesday, September 13, 2011 3:04 PM

Answers

  • Hi,

    When Microsoft Dynamics CRM Server 2011 and SQL Server are installed on different computers, they must be in the same Active Directory directory service domain.

    For each organization, Microsoft Dynamics CRM stores all customer relationship management data in a SQL Server database and use windows authentication for making connection with the SQL Server database also SSRS will not work in this scenario. For further information you may reffer: http://technet.microsoft.com/en-us/library/gg554716.aspx


    Jehanzeb Javeed

    http://worldofdynamics.blogspot.com
    Linked-In Profile |CodePlex Profile

    If you find this post helpful then please "Vote as Helpful" and "Mark As Answer".
    • Proposed as answer by Jehanzeb.Javeed Tuesday, September 13, 2011 3:26 PM
    • Edited by Jehanzeb.Javeed Tuesday, September 13, 2011 3:27 PM
    • Marked as answer by Paul Dowman Tuesday, September 13, 2011 3:27 PM
    Tuesday, September 13, 2011 3:26 PM

All replies

  • Hi,

    When Microsoft Dynamics CRM Server 2011 and SQL Server are installed on different computers, they must be in the same Active Directory directory service domain.

    For each organization, Microsoft Dynamics CRM stores all customer relationship management data in a SQL Server database and use windows authentication for making connection with the SQL Server database also SSRS will not work in this scenario. For further information you may reffer: http://technet.microsoft.com/en-us/library/gg554716.aspx


    Jehanzeb Javeed

    http://worldofdynamics.blogspot.com
    Linked-In Profile |CodePlex Profile

    If you find this post helpful then please "Vote as Helpful" and "Mark As Answer".
    • Proposed as answer by Jehanzeb.Javeed Tuesday, September 13, 2011 3:26 PM
    • Edited by Jehanzeb.Javeed Tuesday, September 13, 2011 3:27 PM
    • Marked as answer by Paul Dowman Tuesday, September 13, 2011 3:27 PM
    Tuesday, September 13, 2011 3:26 PM
  • Perfect - thanks Jehanzeb, I'll feed that back to my client.
    Paul Dowman, CRM Developer
    Tuesday, September 13, 2011 3:28 PM