Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance forum / FnO on SQL 2022, On-prem
Finance forum
Unanswered

FnO on SQL 2022, On-prem

(3) ShareShare
ReportReport
Posted on by Mandeep.S 160
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
Categories:
Administration and Setup
Finance
  • Mandeep.S Profile Picture
    Mandeep.S 160 on at
    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 Profile Picture
    Komi Siabi 12,639 Most Valuable Professional on at
    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 Profile Picture
    Mandeep.S 160 on at
    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 Profile Picture
    Komi Siabi 12,639 Most Valuable Professional on at
    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 ? 

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

Replay: Dynamics 365 Community Call ERP Edition | October 9, 2024

Another great gathering of our Community!

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,572 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,706 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans