Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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 Microsoft Employee

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

  • Suggested answer
    Charles Abi Khirs Profile Picture
    Charles Abi Khirs 3,569 on at
    RE: Moving databases to a new SQL server

    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.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Moving databases to a new SQL server

    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

  • Charles Abi Khirs Profile Picture
    Charles Abi Khirs 3,569 on at
    RE: Moving databases to a new SQL server

    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 Microsoft Employee on at
    RE: Moving databases to a new SQL server

    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.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Moving databases to a new SQL server

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

    Paul

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans