web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Answered

How to install Reporting Extensions on SQL Server 2019?

(0) ShareShare
ReportReport
Posted on by 10

I want to do a clean install of Dynamics 365 version 9.1. I understand that in order to get 9.1, you have to first install 9.0 and then upgrade to 9.1.

I have two brand new servers with Windows Server 2019. One of them has SQL Server 2019 and SQL Server Reporting Services. These version should be supported by Dynamics 9.1.

But these 2019 versions are NOT supported by Dynamics 9.0. Doesn't that mean that I have to first install 9.0 into an unsupported operating system? Or is there something I'm missing?

I tried that and it worked. I was able to install the 9.1 server and update 1.10.

...But I am unable to install Microsoft Dynamics 365 Reporting Extensions on the SQL Server. When the installer gets to the point where I have to select SSRS instance, it doesn't provide any values to choose from. I looked up this issue and found that the problem relates to SQL Server versions 2017 and higher prior to Dynamics 9.0.3 update. There have been some hardcore suggestions on how to fix it, modifying installation files and registry. Such discussion can be found from this thread:    

But that cannot be Microsoft's official way to do the install, right? So how am I supposed to install Microsoft Dynamics 365 Reporting Extensions for Dynamics 9.1 on SQL Server 2019, since the "pre-requisite" 9.0 does not support SQL Server 2019?

pastedimage1655288236893v1.png

I have the same question (0)
  • Verified answer
    PhilipK Profile Picture
    613 on at

    Hi Tommi.

    You solve this by utilizing the "Slipstream" approach which is basically applying a later update(CU) for the v9.0 SRS Data connector RTM installer.
    Personally I've slipstreamed it with Dynamics 365 v9.0 - Update 0.9(which I can confirm works with Reporting Services with SQL Server 2019, CU14) but as the article below is addressing SQL 2017 Reporting Services I suggest you use latest update available for 9.0.
    https://community.dynamics.com/crm/f/microsoft-dynamics-crm-forum/315735/crm-v9-on-premise-unable-to-install-srs-data-connector-reporting-services-extension

    Best regards.
    Philip

     

  • TommiSalminen Profile Picture
    10 on at

    I was afraid of that., but thanks.

    Doesn't that also mean that there is no convenient way to do that? So even if Dynamics 9.1 supports SQL Server 2019, there is no SQL Server 2019 compatible installer. You have to do some pretty shady business to get it installed. How is this problem not addressed by Microsoft?

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Tom_Gioielli Profile Picture

Tom_Gioielli 170 Super User 2025 Season 2

#2
#ManoVerse Profile Picture

#ManoVerse 70

#3
Jimmy Passeti Profile Picture

Jimmy Passeti 50 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans