Finance | Project Operations, Human Resources, ...

FnO on SQL 2022, On-prem

(1) Share

Report

Posted on by Mandeep.S

217

Hello,

Has anyone had experience in deploying SQL 2022 for on-prem D365 FnO (10.0.40)?

I'm attempting to move my existing PROD deployment from SQL 2019 to 2022 and facing some challenges:

1. The SSIS installation requires Integration services + Client connectivity SDK... the latter is removed from SQL 2022.

Any ideas if the SDK is needed or to be installed as an independent component? Tried searching, couldn't find anything though.

2. On the SSRS vm deployment. The Configure-Prereqs script kept looping - prompting for a restart after .Net Framework 4.72 deployment. When I cancelled the restart prompt the .Net Framework showed as installed but on executing Test-D365FOConfiguration script threw an error stating that the .Net Framework could not be found.

Any ideas around this?

Could not find any SQL 2022 specific documentation on D365 on-prem installation. Any help or direction is deeply appreciated.

Thanks

All responses (9)

Answers (0)

Mandeep.S 217 on at

Like (0)

Report

FnO on SQL 2022, On-prem

Hi Komi Siabi,

Haven't progressed further. Posted another thread for the Report Deployment failure on SQL 2022.

Thanks for the nudge.
Komi Siabi 12,711 Most Valuable Professional on at

Like (0)

Report

FnO on SQL 2022, On-prem

Dear Mandeep,

We did not get you hear the final update on this.
Komi Siabi 12,711 Most Valuable Professional on at

Like (0)

Report

FnO on SQL 2022, On-prem

Hi Mandeep.S ,

Your post is not about ReportService deployment failure but .Net framework. Please confirm if the solution proposed worked. Let's open a new thread on the ReportService deployment failure.
I just completed 10.0.40 on premises deployment few hours ago and I had series of issue with SSRS deployment :D.

I suggest you open a new thread with the details issue , probably we can be of help.
Mandeep.S 217 on at

Like (0)

Report

FnO on SQL 2022, On-prem

Dear Komi,

Thanks for your response.

I will try and edit the NodeTopoligyDefinition.xml but I don't think the ReportService deployment failure is due to the .Net Framework 4.72. Your solution might fix the reboot loop caused by executing the Confiure-prereqs.ps1 script on the SSRS vm, but I still need to find a solution for the deployment failure.
Suggested answer

Komi Siabi 12,711 Most Valuable Professional on at

Like (2)

Report

FnO on SQL 2022, On-prem

Hi Mandeep,

The infrastructure scripts(.2.22.2) you are using is for pre version 42 which requires .net framework 48 which is install on Windows server 2022 installed by default.

The work around is to update the NodeTopologyDefinition.xml file on the SSRS VM.

YourSSRSFQDN\D365FO-OP

Look out for lines where you have application and the ref is NET472 then lower the finalVersion to .40

Look out for lines where you have application and the ref is NET48 then lower the initialVersion to .41

<Application ref="NET472" displayName="Microsoft .Net Framework" name="Microsoft .Net Framework" installerName="ndp472-x86-x64-allos-enu.exe" minimumVersion="461808.0" maximumVersion="461814.0" initialVersion="10.0.11" finalVersion="10.0.40"/>

<Application ref="NET48" displayName="Microsoft .Net Framework" name="Microsoft .Net Framework" installerName="ndp48-x86-x64-allos-enu.exe" minimumVersion="528040.0" initialVersion="10.0.40" />

Please, look out for multiple lines and do the change.

Copy the update file to all nodes.
Mandeep.S 217 on at

Like (0)

Report

FnO on SQL 2022, On-prem

Post restart the Test script doesn't detect the .Net Framework 4.72.

If I install the .Net Framework manually, the installer throws a message stating its already installed.
Komi Siabi 12,711 Most Valuable Professional on at

Like (0)

Report

FnO on SQL 2022, On-prem

Hi,

After you install .Net Framework and restart. Run Configure-Prereqs, complete and Test-Confg... and tell us the outcome.
Mandeep.S 217 on at

Like (0)

Report

FnO on SQL 2022, On-prem

So far I have tried installing with Windows 2019 and 2022. Both have the same outcome - SSRS extensions are unable to deploy for SQL/SSRS 2022.

Logs:

[10/14/2024 11:34:02 AM]: @{AccountListToAccessReports=xxx\svc-s13axsf$; DataEncryptionCertificateThumbprint=94D486D300433EFB7DB61B7D3F409E88B137C03B; DataSigningCertificateThumbprint=38423E20D053FBCBDEEDE755AB2A7548A6E0A831; EnableSecurity=True; IsServiceFabricDeployment=True; ReportingClientCertificateThumbprint=820EF33E0722A7707A5171DCCE17E762D7214222; SsrsHttpsPort=443; SsrsServerFqdn=SBOX10-SSRS.xxx.com; SsrsSslCertificateThumbprint=2f86e1bbff7cccfc4441b14ece866a525508d4a7}

[10/14/2024 11:34:02 AM]: Install AX SSRS extension with HTTPS endpoints.

[10/14/2024 11:34:02 AM]:

[10/14/2024 11:34:02 AM]: @{AccountListToAccessReports=xxx\svc-s13axsf$; DataEncryptionCertificateThumbprint=94D486D300433EFB7DB61B7D3F409E88B137C03B; DataSigningCertificateThumbprint=38423E20D053FBCBDEEDE755AB2A7548A6E0A831; EnableSecurity=True; IsServiceFabricDeployment=True; ReportingClientCertificateThumbprint=820EF33E0722A7707A5171DCCE17E762D7214222; SsrsHttpsPort=443; SsrsServerFqdn=SBOX10-SSRS.xxx.com; SsrsSslCertificateThumbprint=2f86e1bbff7cccfc4441b14ece866a525508d4a7}

[10/14/2024 11:34:02 AM]: Start installing AX SSRS extensions ...

[10/14/2024 11:34:02 AM]: C:\ProgramData\SF\SBOX10-SSRS\Fabric\work\Applications\ReportingService_App5\ReportingBootstrapperPkg.Code.1.0.20240725\Scripts\AxReportVmRoleStartupTask.exe

[10/14/2024 11:41:12 AM]: Searching SSRS 2022 WMI object

[10/14/2024 11:41:12 AM]: Found SSRS 2022 WMI object

[10/14/2024 11:41:12 AM]: Remove all HTTP URLs...

[10/14/2024 11:41:17 AM]: Removed URL Application=ReportServerWebService UrlString= http://+:80
System.Management.Automation.RuntimeException: Error occurred when running AxReportVmRoleStartupTask.exe to install extension. Please see details in events for AX-ReportPVMSetup.
[10/14/2024 11:41:17 AM]: Error: Failed to install AX SSRS Extension components.

SSRS Configure... reboot loop after deploying .Net Framework 4.72

SSRS deployment failure
Komi Siabi 12,711 Most Valuable Professional on at

Like (0)

Report

FnO on SQL 2022, On-prem

Hey,

You are indeed right, the components are not available in 2022 sql. But I doubt if that would have any impact on the deployment.

As for the .Net Framework 4.72 error on SSRS could you share a screenshot ?