Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / 10.0.40 On-premise dep...
Finance | Project Operations, Human Resources, ...
Suggested answer

10.0.40 On-premise deployment failure with SQL 2022

(1) ShareShare
ReportReport
Posted on by Mandeep.S 217
Hello,
 
I recently tried a on-premise sandbox deployment of 10.0.40 with SQL 2022 Ent. database.
 
Faced 2 issues:
1. Client SDK missing from the Installation options in SQL 2022 (posted on another thread)
2. Report Extension deployment failure. The event log doesn't give a lot of detail - just that Report Extension component deployment failed.
 
System.Management.Automation.RuntimeException: Error occurred when running AxReportVmRoleStartupTask.exe to install extension. Please see details in events for AX-ReportPVMSetup.
[10/24/2024 11:41:17 AM]: Error: Failed to install AX SSRS Extension components.
 
The official Microsoft documentation states support for up to SQL 2022 (CU12).
 
Versions used:
1. Microsoft SQL Server 2022
2. SQL 2022 Reporting Services 16.0.8969
 
Would appreciate support in resolution. Thanks
  • ArmaanAlam Profile Picture
    ArmaanAlam 5 on at
    10.0.40 On-premise deployment failure with SQL 2022
    Hi Sandeep,
     
    I have experience the same error on 10.0.40 few days back i have resolved this by using 17.9.1 SSMS on SSRS. please also see log at AX-PVMREPORT in event viewer.
     
    may be you will find the Domain\svc-RS$ is unable to login on sql.
     
    also check ./TestD365configuration.ps1
     
    Regards,
    Armaan
  • Suggested answer
    irfan sial Profile Picture
    irfan sial 116 on at
    10.0.40 On-premise deployment failure with SQL 2022
    Hi,
     
    Please correct if i am wrong. I think you are missing to install Nuget package file.

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

photo of Muhammad Affan

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

thumbnail image of a pie chart section

Top 10 leaders for November!

Congratulations to our November super stars!

thumbnail image of the word Tip

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,391 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans