Dynamics Community Forum Thread Details

An error has occurred after moving CRM Applications and DB to new servers

Hi,

I'm currently helping a client to move their on prem dynamics applications to new servers. We have thus far been able to backup and restore the sql db to the new server, and able to point the existing organisations to the new db. Albeit that we needed to change the MSCRM_Config using these steps:

1. Changed registry to point to new SQL Server

2. Changed all organization rows/records in MSCRM_CONFIG ->Organization table to use new server

a. Open SQL Server Managment Studio->browse down to MSCRM_CONFIG->Tables-> find dbo.Organization->Right click->Edit top 200 rows

b. Find "Connection string" column and change "data source=" value to your new SQL server instance name. (in my case was "devsql006" ->new sql server "devsql006\sql2012")

c. Find "SQLServerName" column and change data to your new SQL Server instance name ("devsql006"->"devsql006\sql2012")

then it worked perfectly, I hope it will help someone.

So the applications and the DB are connected.

However, now when we try to navigate to the URL:s, we only get:

"An error has occurred. Try this action again if the problem continues. Contact MS Dynamics 365 admin for help".

So we are pretty much stuck and can't really find where the error is.

We have turned on the event log for the applications, so we will go through that in hopes of finding a clue.

But has someone been in the same situation, and what was that solution?

Thanks in advance for all your help!

Quick Links