Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Installing 2011 - SQL server in different domain RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    1
    Sign in to vote

    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

  • Question
    Sign in to vote
    1
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote
    Perfect - thanks Jehanzeb, I'll feed that back to my client.
    Paul Dowman, CRM Developer
    Tuesday, September 13, 2011 3:28 PM