locked
CRM config with cluster sql RRS feed

  • Question

  • Hi,

    I tried setting up CRM with cluster URL but this is not supported.
    We need to cluster required databases now and change URL on CRM.
    We need to run SQL query to update it. (sample from MS siee below)
    (Update Organization set ConnectionString = 'Provider=SQLOLEDB;Data Source=AG_Listener_Name;Initial Catalog=OrganizationName_MSCRM;Integrated Security=SSPI' where DatabaseName = 'OrganizationName_MSCRM')
     
    Could you confirm which DB’s need to be clustered?


    A.Kamalesh

    Wednesday, June 11, 2014 5:36 AM

All replies

  • To clarify, if you are using clustered SQL, then this doesn't affect any URLs. All you might need to change is the connection string to the SQL cluster.

    Normally you would cluster the MSCRM_Config and all the organisation databases


    Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk

    Wednesday, June 11, 2014 9:26 AM
    Moderator