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

(0) Share

Report

Posted on by LeonBouquiet

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.

All responses (2)

Answers (2)

Verified answer

Hüseyin Sahin on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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