Answered by:
unable to point an existing CRM 2011 installation to a new sql server via cname

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
-
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 PMModerator -
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- Marked as answer by RhettClintonMVP, Moderator Wednesday, March 23, 2011 5:26 PM
Tuesday, March 22, 2011 7:27 PMModerator
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 PMModerator -
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 PMModerator -
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
- Changed type ravi v sagi Friday, March 18, 2011 4:29 PM
- Merged by DavidJennawayMVP, Moderator Tuesday, March 22, 2011 7:28 PM Same topic
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.ukFriday, March 18, 2011 4:29 PMModerator -
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 ProfileFriday, March 18, 2011 5:25 PMModerator -
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 hapenMonday, 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 ProfileMonday, March 21, 2011 8:06 PMModerator -
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- Marked as answer by RhettClintonMVP, Moderator Wednesday, March 23, 2011 5:26 PM
Tuesday, March 22, 2011 7:27 PMModerator -
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 PMModerator -
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