Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics 365 | Integration, Dataverse...
Answered

Is an in-place upgrade to SQL2022 / SSRS 2022 supported?

(0) ShareShare
ReportReport
Posted on by 5

Hi all,

I'm running an on-premise instance of Dynamics 365 Customer Engagement (version 9.1.14.17), with all roles deployed on a single server. This server is currently running SQL Server 2019 with Reporting Services 2019, and I'd like to do an in-place upgrade of both to SQL Server 2022 and Reporting Services 2022.

1) Are SQL Server 2022 and Reporting Services 2022 even supported? According to this page, only SQL Server upto 2019 is supported, although SQL2022 was released after that page was published.

2) I can't find any guidance on how to do such an in-place upgrade to SQL2022/SSRS2022 (or 2019 for that matter); the closest I could find was this post where the conclusion is "Don't see a problem then with your approach."

I've tried the in-place upgrade myself (after creating a VM snapshot first), and I've found that the in-place SQL Server upgrade from 2019 to 2022 leaves CRM working without a problem (haven't tested this extensively yet though).
Upgrading SSRS from 2019 to 2022 however, breaks the reporting part of CRM, which intuitively makes sense as SSRS2022 probably exposes a new API that the SrsDataConnector has no knowlegde of.
When I look in the CRM Reporting Extensions trace log, I only see "Could not load file or assembly 'Newtonsoft.Json, Version=11.0.0.0...".

Provided SSRS2022 is supported, does anyone know how to get it working?
Any help would be greatly appreciated.

  • Verified answer
    RE: Is an in-place upgrade to SQL2022 / SSRS 2022 supported?

    Hello LeonBouquiet,

    I second Haig Liu.

    From Dynamics Infrastructure perspective here are some details:

    SQL 2022 and SSRS 2022 are currently not supported. (See our software requirements: learn.microsoft.com/.../software-requirements-for-microsoft-dynamics-365-server

    When we officially support SQL 2022 and other components our Software requirements page will be updated accordingly.

    Generally an In-Place upgrade for SQL or CRM is not recommended as there is a high risk that something may fail and a rollback / restore would be required.

    A side by side deployment is recommended meaning you build up a new environment and you move the CRM Organization Database to it.

    So you can test without impacting the "running" environment.

    Regarding SQL 2022 there is no ETA when and if it will be supported as we require time to test and prepare Rollups if code fixes are required.

    The Newtonsoft.Json error as I am aware of is worked on but I am not sure at this stage which Update package will resolve it.

    My recommendation here is to raise a case to our Clients Team -> Dynamics CRM -> SSRS / reporting they can provide you more details on the defect.

  • Verified answer
    Haig Liu Profile Picture
    Haig Liu Microsoft Employee on at
    RE: Is an in-place upgrade to SQL2022 / SSRS 2022 supported?

    Hi LeonBouquiet,

    I'm afraid Dynamic does not support it for now, as this is not an urgent update, and this may take a while to wait.

    I suggest you raise a support ticket: 

    https://admin.powerplatform.microsoft.com/support

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 Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,492 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans