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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / CRM V9 on-premise: Una...
Microsoft Dynamics CRM (Archived)

CRM V9 on-premise: Unable to install SRs Data Connector (Reporting Services Extension)

(0) ShareShare
ReportReport
Posted on by Community Member

Hello Experts,

We have the following setup on Azure. 

CRMSRV: Windows Server 2016 DC Edn, Domain Controller, CRM Application Server

CRMDB: Windows Server 2016 DC Edn, SQL Server 2017 Database and Reporting Services, CRM DB Server

CRM is up and running.

Trying to install SRS Data Connector, which came along with the CRM v9 installer package, on the DB Server. During installation after selecting the DB Server the SSRS instance is blank. When checked install logs, the following warning was found:

21:23:54|Warning| Could not find a local RS instance corresponding to the reporting url http://crmdb/reportserver for organization D365V9

When we tried with similar setup on local servers it is the same. Is there any known issues with V9 Reporting Services Installation? 

Any help will be appreciated.

Regards

AbD

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    gdas Profile Picture
    gdas 50,091 Moderator on at

    Hi,

    I think you should use Microsoft SQL Server 2016 Enterprise, with Service Pack 2.

    docs.microsoft.com/.../software-requirements-for-microsoft-dynamics-365-server

    community.dynamics.com/.../269427

    Also see below references -

    community.dynamics.com/.../312959

  • serg6006 Profile Picture
    serg6006 10 on at

    Hi,

    docs.microsoft.com/.../microsoft-dynamics-365-reporting-requirements - For Dynamics 365 for Customer Engagement reporting, you can use the following SQL Server editions

    - Microsoft SQL Server 2017 Enterprise

    - Microsoft SQL Server 2017 Standard

    Requires Microsoft Dynamics 365 Server, v9.0 (on-premises) Update 0.3.

    But to install the Update 0.3 you need to install the distribution SRS Data Connector, which is a contradiction. Jest Microsoft!

  • Sam Alex Profile Picture
    Sam Alex 6 on at

    I just posted a question similar to this.  SQL 2017 is supported with Update 0.3, but how can I install CRM v9 on SQL 2017 if Update 0.3 has to be applied after installation yet it's a prereq for SQL 2017?

  • nickmangioros Profile Picture
    nickmangioros 470 on at

    Hi,

    I had the same issue with SQL Server 2017 and Reporting Services

    I think it is not supported you will need to roll back your SQL Server 2016 for it to work

  • serg6006 Profile Picture
    serg6006 10 on at

    The solution is here https://blog.hshilling.com/Blog/post/dynamics-365-v9-srs-data-connector-and-sql-20171

  • Suggested answer
    WayneMX Profile Picture
    WayneMX 4 on at

    Unfortunately that blog has gone down, but after many hours of searching this entry helped me get past the problem of having it not visible on SSRS 2017

    community.dynamics.com/.../getting-error-while-installing-microsoft-dynamic-crm-365-v9-reporting-extension

    With the RTM version of the reporting extensions for Dynamics 365 -- there was an issue as it related to finding the SSRS instance name with SSRS 2017. The SSRS team changed the location in the registry that previously stored the instance name, and the installer for Dynamics 365 reporting extensions was not referencing the new location. This has been addressed in a later update for the reporting extensions installer -- microsoft.com/en-us/download/details.aspx?id=58153

    However, the 0.3 update is not a stand-alone installer. So, there are steps needed here to slipstream the install to include 0.3 with the RTM bits and allow the selection of the reporting services instance name to complete.

    I would suggest to remove the manually added registry entries for the SSRS instance, slipstream the install, and then you should be able to select the SSRS instance name from the drop down selection in the reporting extensions setup. Here is a summary of the steps to slipstream the 0.3 update into the RTM install for the Dynamics 365 SSRS reporting extensions:

    1. Copy the SSRS reporting extensions folder from the RTM bits of Dynamics 365 V9 on premise and paste on the SSRS server in a directory such as:  c:\installMedia\CRMV9RTM
      1. If you don't have the RTM bits, download the server package from: https://www.microsoft.com/en-us/download/details.aspx?id=57478
      2. After downloading the .exe, you can extract the contents by command line
        • CRM9.0-Server-ENU-amd64.exe /extract:c:\installMedia\CRMV9RTM
    2. Download the 0.3 update for SSRS reporting extensions from: https://www.microsoft.com/en-us/download/details.aspx?id=58153
      1. File named: CRM9.0-Srs-KB4490599-ENU-Amd64.exe
      2. Extract the contents of this file using command line: CRM9.0-Srs-KB4490599-ENU-Amd64.exe /extract:c:\installMedia\SSRSExtUpdate
    3. There should now be two directories extracted on the SSRS server:
      1. c:\installMedia\CRMV9RTM\SrsDataConnector -- containing the RTM bits
      2. C:\installMedia\SSRSExtUpdate -- containing the 0.3 SSRS reporting extension update bits
    4. Edit the install-config.xml file in notepad from the c:\installMedia\CRMV9RTM\SrsDataConnector directory
      1. Change the <patch update="false"></patch> line to:
      2. <Patch update="true">C:\installMedia\SSRSExtUpdate\Srs_KB4490599_amd64_1033.msp</Patch>
      3. Save the file
    5. Run the install against the RTM bits of the SRS Reporting Extensions using Command prompt and the /config parameter
      1. Open Command prompt, change directory to the location of the RTM SSRS Reporting extensions media
        • Cd c:\installMedia\CRMV9RTM\SrsDataConnector
      2. Run the SetupSrsDataConnector.exe with the /config parameter pointing to the install-config.xml file:
        • SetupSrsDataConnector.exe /config c:\installMedia\CRMV9RTM\SrsDataConnector\install-config.xml

    The above steps will then push the 0.3 update into the RTM install and you should be able to select the reporting services instance name on the SSRS 2017 server. (make sure you are installing the reporting extensions for Dynamics 365 on the server where SSRS is installed and not on the Dynamics 365 server)

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans