web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Moving databases to a ...
Microsoft Dynamics CRM (Archived)

Moving databases to a new SQL server

(0) ShareShare
ReportReport
Posted on by Community Member

We need to move our databases to a new SQL server for CRM 2016.

I found this article for 2013, but could not find anything for CRM 2015 or 2016.  https://technet.microsoft.com/en-us/library/hh699806(v=crm.6).aspx

I followed this article.  While things appear to be working properly, in my CRM Deployment manager it still shows my old SQL server listed and the role is SQL Server.  It shows the new SQL server with a role of SRS Data Connector.

I say things appear to be working correctly because I can login to CRM.  I also imported one organization from the old server and the import ran correctly.

In the config database, the dbo.Server table lists the old SQL with a role of 256 and the new SQL server with a role of 4.  Judging by my old config table, I want my SQL server to have a role of 260.  (I am not sure it is safe to change this in SQL).

Any idea how I eliminate the old SQL server completely and make sure my new SQL server has all the correct roles?

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Hi,  Currently dealing with similar issue.  Where you able to find an answer for your question?  Regards,

    Paul

  • Community Member Profile Picture
    Community Member on at

    No -- I followed the articles I found to take the disable the servers in the CRM deployment Manager; change the registry key for the SQL server name; and then Add the organization back in.   If I look under "servers" in deployment manager, I still have old SQL servers that don't exist, but they don't seem to be hurting anything.  I don't know how to get rid of them in the correct way, so I just left them.

  • Charles Abi Khirs Profile Picture
    Charles Abi Khirs 3,569 on at

    Hello,

    In the deployment manager, did you change the sql server name to the new one?

    Regards,

    Charles Abi Khirs.

  • Community Member Profile Picture
    Community Member on at

    I don' think there is a way to do it in there.  I changed the registry key:  Change HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSCRM - Configdb  

    This old, but helpful:  support.microsoft.com/.../how-to-move-the-microsoft-dynamics-crm-4-0-deployment

  • Suggested answer
    Charles Abi Khirs Profile Picture
    Charles Abi Khirs 3,569 on at

    Yes sure, the main change is the one in the registry. It is the one that is used by the CRM in order to connect and that's why you don't have an issue opening the CRM.

    As for the deployment manager, If you are not able to change the sql server from the deployment manager (which might raise issues if you need to change something on the organizationlevel) , you can update the MSCRM_CONFIG database directly from SQL using an update statement to point to the new server (don't forget to backup before the update).

    Even if it looks unsupported, I already did it and successfully reflected into the deployment manager without any future issues.

    Hope this helps!

    If found helpful, please mark the answer as verified.

    Charles Abi Khirs.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
JS-09031509-0 Profile Picture

JS-09031509-0 3

#2
AS-17030037-0 Profile Picture

AS-17030037-0 2

#2
Mark Eckert Profile Picture

Mark Eckert 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans