Customer Engagement & Dynamics CRM Forum

Expand all | Collapse all

database updates BUT NOT THE CRM itself?

  • 1.  database updates BUT NOT THE CRM itself?

    GOLD CONTRIBUTOR
    Posted 11 days ago
    Hello,
    For anyone using Dynamics CRM 2016 on premise...Have you upgraded the SQL Server database to a higher version (for example, SQL 2014 to SQL 2016)? Did you run into any problems? Did you have to run the Deployment Manager to change anything? Are there any shared folders with specific rights, registry settings, or certificates to be concerned about?

    The database itself is remaining on the same location of the same server. We just want to upgrade SQL Server and leave the CRM as is.

    Any issues? Any recommendations?

    Thanks for your help,

    ------------------------------
    Rod Carlson
    Database Administrator
    Chicago
    ------------------------------
    The first step toward cloud success. - Migrate from CRM to D365 with expert guidance from Microsoft. I'm Ready


  • 2.  RE: database updates BUT NOT THE CRM itself?

    SILVER CONTRIBUTOR
    Posted 10 days ago
    Hi There

    As a DBA I would highly recommend that you NOT do an in place upgrade of SQL. in fact I think the preferred method is to build your new SQL Server and install the SQL Version required. Copy (Backup & Restore) All the databases involved to the new server.

    There is MS documentation on moving the databases which is quite easy to follow.

    Apart from anything else, it gives you a fallback position if anything goes wrong.
    Paul Smith
    Business Systems & Integration Analyst
    SSAFA, the Armed Forces charity. Queen Elizabeth House, 4 St Dunstan's Hill, London. EC3R 8AD
    T: 
    +44 20 7463 9363
    E: 
    Paul.Smith@ssafa.org.uk
    W: 
    www.ssafa.org.uk
    The information in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this e-mail by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Registered Charity No. 210760 Est. 1885. Registered charity in England and Wales No. 210760, in Scotland No. SC038056 and in Republic of Ireland No. 20202001. Est. 1885.



    The first step toward cloud success. - Migrate from CRM to D365 with expert guidance from Microsoft. I'm Ready


  • 3.  RE: database updates BUT NOT THE CRM itself?

    GOLD CONTRIBUTOR
    Posted 10 days ago
    Thanks for your advice Paul,

    Do you have any recommended articles/documents?

    Are you opposed to the change of database overall, or are you saying it is only safe if a new server is setup as a fresh install?

    Did you experience problems in the past with the CRM when you did this?

    ------------------------------
    Rod Carlson
    Database Administrator
    Chicago
    ------------------------------

    The first step toward cloud success. - Migrate from CRM to D365 with expert guidance from Microsoft. I'm Ready


  • 4.  RE: database updates BUT NOT THE CRM itself?

    Posted 9 days ago
    The documentation for migrating the database but not the application server hasn't changed much since crm 2011. I recently migrated our 2016 environment off of a sql 2012 box to a sql 2014
    there are a couple of walk - throughs out there via google search, here is one I used...
    https://docs.microsoft.com/en-us/previous-versions/dynamics-crm2011/implementation-guide/hh699772(v=crm.5)

    a few issues I ran into.
     - the security groups  reporting group {}, sqlaccessgroup{}, privreporting group {}, needed to be configured on the sever  as logins, the CRM deployment manager database import wizard failed to do this automagically
    - i remember some issue with the ssrs url not being recognized.. but i can't remember how i resolved it... works now :)
    - none of the ssrs reports that were configured to be internal to crm moved over so those had to be manually migrated and reconfigured
    - databases ended up fragmented to all heck after the restore


    ------------------------------
    Alex Kinney
    CRM analyst
    Wingspan Care Group
    Shaker Hts OH
    ------------------------------

    The first step toward cloud success. - Migrate from CRM to D365 with expert guidance from Microsoft. I'm Ready


  • 5.  RE: database updates BUT NOT THE CRM itself?

    GOLD CONTRIBUTOR
    Posted 8 days ago
    thanks for your help

    ------------------------------
    Rod Carlson
    Database Administrator
    Chicago
    ------------------------------

    The first step toward cloud success. - Migrate from CRM to D365 with expert guidance from Microsoft. I'm Ready


If you've found this thread useful, dive deeper into User Group community content by role