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.