Dynamics crm connection string

(0) Share

Report

Posted on by Adel Orabi

150

Hello,

kindly note that i'm moving my dynamics CRM on premise application to a new server on premise also, however, i created new image of the dynamics crm and i've restored the database to the new SQL server. My question is how can i connect the new CRM to the new SQL database?? i mean can i change the connection string of my SQL?

if yes from where can i do it!!

Thank you for your help,

Adel,

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (2)

Verified answer

David Jennaway 14,065 on at

Like (0)

Report

RE: Dynamics crm connection string

The way to do this is to use CRM Deployment Manager, and Import the Organisation Database.

Was this reply helpful? Yes No
Verified answer

Kokulan 18,054 on at

Like (1)

Report

RE: Dynamics crm connection string

Hi

You shouldn't have to manually set the connection string for the database, the connection string will be updated by the Import Process.

Since you have already restored the database, one step is already completed.

The Next Step is to do the Organisation Import, please follow the steps described in these links

Please make sure the AD account you are using to import the Org is a Domain Admin account or an AD account that has permissions to create/update AD OUs

[View:https://arunpotti.wordpress.com/2015/04/29/how-to-import-crm-orgnization-using-crm-sql-server-backup-file/]

[View:https://www.c-sharpcorner.com/UploadFile/d2ee01/steps-to-import-organization-database-in-ms-dynamics-crm-201/]

Hope this helps

Was this reply helpful? Yes No
Suggested answer

gdas 50,091 Moderator on at

Like (0)

Report

RE: Dynamics crm connection string

Hi Adel,

As suggested above , the actual process is to do organization import pointing to the DB using Deployment manger after restore the CRM organization database.

However for your information you could find the DB connection string in REGEDIT configuration in the front end server , so you can navigate to registry editor in the front end server and go to - HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSCRM.

You can find the the database details in the Organization table.

Take a look below reference -

community.dynamics.com/.../309920

Was this reply helpful? Yes No
Adel Orabi 150 on at

Like (0)

Report

RE: Dynamics crm connection string

Hi,

So, Always to move from one DB to other DB using the same instance of the CRM we have to import the organization Database of the needed database?

Thank you

Was this reply helpful? Yes No
Adel Orabi 150 on at

Like (0)

Report

RE: Dynamics crm connection string

Today i've tried to run the deployment manager but i'm getting the following issue:

Unable to access the MSCRM_CONFIG database .SQL server does not exist or access denied!!

Please note that i did clone the CRM server to new server!! i didn't install new CRM instance. i cloned the whole server and i need to connect the cloned CRM to the restored database!!

Help please

Best Regards,

Was this reply helpful? Yes No
Suggested answer

gdas 50,091 Moderator on at

Like (0)

Report

RE: Dynamics crm connection string

Hi ,

This is because from the front end server DB connection has broken. When you clone server its nothing but copying everything to the new server , in that case your server is changing which means the new server still trying to connect OLD DB server with the same AD user . You can try to change the registry path from config key which I shared my above post . Also try to open "Organization" table from database and update the database server name. You might need to change the server name as well by going to SQL.

From my experience clone server is not a good way , try to do organization import by taking DB backup in new server with fresh CRM installation.

Was this reply helpful? Yes No
Adel Orabi 150 on at

Like (0)

Report

RE: Dynamics crm connection string

Thank you so much for your help,

Please note that i have 2 new servers. one for the SQL and reporting and one for the CRM application.i finished the DB backup on the SQL server for the CRM databases. If we do a fresh installation so i have to move the process and the security roles and the JAVAscript customization and the workflows , etc..!! for that we did clone the server and we need to connect it to the NEW SQL server

Was this reply helpful? Yes No
Suggested answer

gdas 50,091 Moderator on at

Like (0)

Report

RE: Dynamics crm connection string

You dont need to move the process ,security roles , JAVAscript customization, workflows separately. Those will come automatically when you do organization import in the new server, thats why you need to take organization DB back up to restore in new server -

Take a look below article -

arunpotti.wordpress.com/.../how-to-import-crm-orgnization-using-crm-sql-server-backup-file

Was this reply helpful? Yes No
Adel Orabi 150 on at

Like (0)

Report

RE: Dynamics crm connection string

well noted,

but now i cloned the server and i forced to use this way!!how can i run the deployment manager to be able to import the organization from the NEW SQL server in order to change the connection from the OLD database server to the new one

Best Regards,

Was this reply helpful? Yes No
gdas 50,091 Moderator on at

Like (0)

Report

RE: Dynamics crm connection string

You need to fix those places manually , DB and registry mentioned above post.

Was this reply helpful? Yes No