locked
unable to point an existing CRM 2011 installation to a new sql server via cname RRS feed

  • Question

  • Scenario

    we have a crm 2011 on premises live version installed.It is point to a temperory data base.

    We need to change the data base to a new server.

    We need to point the crm  to a new sql server(database name: ukclk200..) via  cname (created cname :sqlcrm).

    I performed teh following steps.

    backed up the  current config_mscrm and org_mscrm from the existing server and restored it on the new server.

    opened the registry on the crm 2011 server

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSCRM

    changed the datasource in the sub key configdb to point to the cname of the new sql server.

    Note: the planning guide says i need to do the same for  database subkey and for the metabase  subkey

    but i cannot find the database and metabase subkeys in HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSCRM

    I restarted the machine.

    i tried to edit the organisation in deployment administrator but it says it cannot find the data base and/or acess denied.

    But when i clicked the import organization its acually showing me my organisation that i have loaded in the new sql server.when i proceed aat the end of the wizard it again displays saying the sqlserver cannot be found.

    I doubt this is some thing to do with the other two subkeys in registry(database,metabase which i cnnot find).

    all the logins were also copied and i have permissions.

    can any one please help me as with out this we cannot go forward to live sing the live sql server should be called via acname

    thanx in advance

    ravi 

     

     

     

     

    Thursday, March 17, 2011 1:54 PM

Answers

All replies

  • Check out the Organization table in the MSCRM_Config db
    MS CRM Bing'd - http://bingsoft.wordpress.com
    Useful Tools  CRM 4 to CRM 2011 JavaScript Converter Tool
    CRM 2011 OData Query Designer
    CRM Forum Guidance on how to Help Us Help You
    • Marked as answer by ravi v sagi Tuesday, March 22, 2011 10:50 AM
    Thursday, March 17, 2011 2:40 PM
    Moderator
  • the organisation tables in mscrm_config are empty because i have deleted the current organization  and trying to import  it as a new organization

    should i do some this else?

     

    regards

    ravi sagi

    Thursday, March 17, 2011 3:09 PM
  • Does it provide any further details other than it can't be found? Maybe the deployment manager log may have further details.
    MS CRM Bing'd - http://bingsoft.wordpress.com
    Useful Tools  CRM 4 to CRM 2011 JavaScript Converter Tool
    CRM 2011 OData Query Designer
    CRM Forum Guidance on how to Help Us Help You
    Thursday, March 17, 2011 5:10 PM
    Moderator
  • hi

    After some trails i am gettting the error

    "The instance name must be the same as computer name.". This  comes under sql server during the validation.

    it occurs for both imprt and creation of new orgainization.

     

    Fed up with the above process

    I tried to reinstall the crm 2011 and pointing it to a cname (in mycase its sqlcrm.) during the setup

    but its automatically taking the server name after installation in mycase ukclksql01

    Our problem is we need the crm to consider cname so that we can move the sql server when ever we want.

    Our sql servers cannot be accessed on the servernames because its in DR(disaster recovery) and they kepp changing them from time to time

    is there a way out for this?

    this is a pretty common scenerio for any enterprise deployments so am i missing some thing ?

     

    regards

    ravi sagi

     


    Friday, March 18, 2011 11:28 AM
  • i used the cname crmsql03 to install the crm 2011 server

    But its actually storing the squlserver name instead of cname

    the actual point is to enable the systems teams to change the sql server and point the cname to the new one when ever its required but it doesnot seem to hapen

    how can i install a crm using a cname? or can i actually do it?

    is it not supported ?

    my related post

    http://social.microsoft.com/Forums/en/crmdeployment/thread/b5f97365-7a3e-41ae-ae15-60a6e4939b72

     

     

    Friday, March 18, 2011 4:03 PM
  • i managed to get thh existing organisations working after changing the string in organisation and server tables in the mscrm_ ConfigDB

    i changed the sql server names to the cname

    But when i try to import a new organization it says cannot acess on the cname(sqlcrm in this case)

     

     

    help required

     

    regards

    ravi sagi

    Friday, March 18, 2011 4:21 PM
  • One fundamental issue is that CRM will check if the SQL Server name it's been given exists in the sysservers table. This post gives more information and some resolutions.

    However, I think you're open to other possible problems by using a CName for the SQL Server. What's wrong with using actual SQL Server name ?


    Microsoft CRM MVP - http://mscrmuk.blogspot.com  http://www.excitation.co.uk
    Friday, March 18, 2011 4:29 PM
    Moderator
  • David thanx for the rply

     the actual point is to enable the systems teams to change the sql server and point the cname to the new one when ever its required but it doesnot seem to hapen since the crm is storing the physycal server name.

    in our case we cannot use the server name

    But its actually storing the squlserver name instead of cname

    how can i install a crm using a cname? or can i actually do it?

    is it not supported ?

    THis should be pretty common scenerio since microsoft supports moving databases across servers

     

     By the way we are uosing CRM 2011

    regards

    ravi sagi


    Friday, March 18, 2011 4:35 PM
  • I have not tried this personally, but in my experience with CNAME records vs A records it seems that when you enter the CName record in a browser that it redirects to the A Name in DNS. 

    I would think that this might not work as it might install and have registry keys and things pointing to the CNAME but it would really be trying to reach back to the A in the end and fail.

    Is there a reason why you cannot use the A name?


    Jamie Miley
    http://mileyja.blogspot.com
    LinkedIn Profile
    Friday, March 18, 2011 5:25 PM
    Moderator
  • the actual point is to enable the systems teams to change the sql server and point the cname to the new one when ever its required but it doesnot seem to hapen
    Monday, March 21, 2011 10:05 AM
  • Hi i just need one cconfirmation

     

    does dynamics crm 2011 support using sql on cname?

    if not why?

     

    can any one please help me?

    • Marked as answer by ravi v sagi Tuesday, March 22, 2011 10:50 AM
    • Unmarked as answer by ravi v sagi Tuesday, March 22, 2011 10:50 AM
    Monday, March 21, 2011 10:10 AM
  • I would suggest looking into using a clustered db server.  Then if one fails it will repoint and still be up always.  You can then take servers down as needed.

    Unfortunately a quick search of the Implementation Guide for CNAME turns up no hits at all.


    Jamie Miley
    http://mileyja.blogspot.com
    LinkedIn Profile
    Monday, March 21, 2011 8:06 PM
    Moderator
  • Given that you don't seem to be able to get this to work, and also my point re sysservers, then I think it's best to assume that this is not supported.

    I don't see any benefit is using the CName for recovery. It'd be just as easy (and not subject to dns caching issues) to just use CRM Deployment Manager to onnect to a different SQL Server if required. Or you could use database mirroring


    Microsoft CRM MVP - http://mscrmuk.blogspot.com  http://www.excitation.co.uk
    Tuesday, March 22, 2011 7:27 PM
    Moderator
  • Wow, learn something new every day. 


    Jamie Miley
    http://mileyja.blogspot.com
    Linked-In Profile
    Follow Me on Twitter!
    Tuesday, March 22, 2011 9:25 PM
    Moderator
  • Hello,

    I would say stick with trying to get CRM to reference the DNS entry, this is pretty standard for DR set ups and its not too tough and gives big benefits when failing over.

    three things that I found,

    1. IgnoreChecks   registry entry may be of use to you see this post http://darrenliu.wordpress.com/category/installation/

    2. If you are using sql aliases as well as DNS, see here http://darrenliu.wordpress.com/category/installation/

    3. If you are using kerberos authentication for CRM app server to DB its better to use A-Records as the CNames result in invalid correct kerberos tokens.


    Derek

    Wednesday, July 18, 2012 2:59 PM