Customer experience | Sales, Customer Insights,...

How specify SSRS instance name in installation Microsoft Dynamics 365 Reporting Extensions?

(0) Share

Report

Posted on by Business Central

Hi.

In the installation of Microsoft Dynamics 365 Reporting Extensions, when you have to specify SSRS instance name, it comes out empty and I can't choose anything.

I suppose you have to leave the instance that has the report services, which is installed and configured correctly, since it starts without problems.

To access the database I enter Sql Server as 'ComputerName', but to enter Reporting Services I have to do it as 'ComputerName / SSRS'. I don't know if it has anything to do with it.

Can anyone help me or know if I need to install or configure something?

Greetings and thanks.

All responses (8)

Answers (0)

WayneMX 4 on at

Like (0)

Report
RE: How specify SSRS instance name in installation Microsoft Dynamics 365 Reporting Extensions?

For those that found this problem but couldn't find the final solution here, i used this to resolve the issue of having no options in the drop down box

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:

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

If you don't have the RTM bits, download the server package from: https://www.microsoft.com/en-us/download/details.aspx?id=57478

After downloading the .exe, you can extract the contents by command line

CRM9.0-Server-ENU-amd64.exe /extract:c:\installMedia\CRMV9RTM

Download the 0.3 update for SSRS reporting extensions from: https://www.microsoft.com/en-us/download/details.aspx?id=58153

File named: CRM9.0-Srs-KB4490599-ENU-Amd64.exe

Extract the contents of this file using command line: CRM9.0-Srs-KB4490599-ENU-Amd64.exe /extract:c:\installMedia\SSRSExtUpdate

There should now be two directories extracted on the SSRS server:

c:\installMedia\CRMV9RTM\SrsDataConnector -- containing the RTM bits

C:\installMedia\SSRSExtUpdate -- containing the 0.3 SSRS reporting extension update bits

Edit the install-config.xml file in notepad from the c:\installMedia\CRMV9RTM\SrsDataConnector directory

Change the <patch update="false"></patch> line to:

<Patch update="true">C:\installMedia\SSRSExtUpdate\Srs_KB4490599_amd64_1033.msp</Patch>

Save the file

Run the install against the RTM bits of the SRS Reporting Extensions using Command prompt and the /config parameter

Open Command prompt, change directory to the location of the RTM SSRS Reporting extensions media

Cd c:\installMedia\CRMV9RTM\SrsDataConnector

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)
Antonio Llanero 95 on at

Like (0)

Report

RE: How specify SSRS instance name in installation Microsoft Dynamics 365 Reporting Extensions?

Hi Tom.

That was the problem. I have already been able to solve it. Thank you very much for everything and greetings.
Antonio Llanero 95 on at

Like (0)

Report

RE: How specify SSRS instance name in installation Microsoft Dynamics 365 Reporting Extensions?

Hi Gary. Thanks for answering.

The two URL links open correctly in my browser.

I don't know how to know if the version of SQL Server is compatible with that of CRM. The version I have installed of SQL Server is 2019.150.2000.5 and that of Dynamics 365 CRM is 9.0.2.3034. I think they are the latest versions in both.

As for the user, I am with a domain and I have full administrator permissions. I don't think it's that because I've never had problems.

On the other hand, I have looked at the link that you have passed me and what has happened to you:

<crmsetup>

<srsdataconnector>

<installtype></installtype>

<configdbserver></configdbserver>

<autoupdateconfigdb>1</autoupdateconfigdb>

<autogroupmanagementoff>0</autogroupmanagementoff>

<instancename>MSSQLSERVER</instancename>

<configsku>OnPremise</configsku>



<webstore enabled="false" configdb="false" />

<monitoring>



<serviceaccountname></serviceaccountname>

<serviceaccountpassword></serviceaccountpassword>

</monitoring>

<patch update="false"></patch>

</srsdataconnector>

</crmsetup>

Can it be that the next instance name is MSSQLSERVER which is the default one? My installation is done with that instance because I did it by default, but when entering Sql Server, I do not indicate any. I tried to erase it or put another one, but the choice of instance in the installation still goes blank.

Greetings and thanks.
Suggested answer

Tom Jeffries 145 on at

Like (1)

Report

RE: How specify SSRS instance name in installation Microsoft Dynamics 365 Reporting Extensions?

Hi Antonio,

I've located your support case and given some guidance to the engineer who's working with you. If you are on SQL 2017, this is a known issue.

The gist of the fix is that this was a known issue when 9.0.0 came out, and was officially resolved in version 9.0.3. This is mentioned here: docs.microsoft.com/.../microsoft-dynamics-365-reporting-requirements

However you can't normally install the 9.0.3 Reporting Extensions until 9.0.0 is fully installed. To get around this, you can force the installer to apply the 9.0.3 update during installation. One member of the broader D365 community has shared suggested steps here: blog.hshilling.com/.../dynamics-365-v9-srs-data-connector-and-sql-20171

Note this is not official Microsoft documentation, but these are the same steps support would provide.
Suggested answer

Gary Letter 1,267 on at

Like (0)

Report
RE: How specify SSRS instance name in installation Microsoft Dynamics 365 Reporting Extensions?

Hi Antonio,

A few more things to try:

Double-check your prerequisites:

Make sure that SSRS is correctly configured. In Reporting Services Configuration Manager, click on the links for the Report Manager URL and Web Service URL and confirm that they open in a browser.

Make sure that the version of SQL Server is supported for the CRM version.

If it is not already there, add the Service account for SSRS Report Server Configuration Manager to the PrivReportingGroup in Active Directory.

Try running the installation from an XML configuration file. See the link below for details. Make sure to specify the name of the SQL instance, which could be different from the name of the SQL Server.
https://docs.microsoft.com/en-us/previous-versions/dynamics-crm4/implementation-guide/dd979397(v=crm.6)?redirectedfrom=MSDN

Gary Letter
NextLevel Business Systems

If you find the answer useful, please mark it as verified.
Antonio Llanero 95 on at

Like (0)

Report

RE: How specify SSRS instance name in installation Microsoft Dynamics 365 Reporting Extensions?

Hi.

Thank you for your answers.

Gary, I'm on a virtual machine, but everything is installed locally. I've tried what you say, but it's still blank.

Tom, I'm already in conversation with a Microsoft person since last week, but so far, he hasn't been able to help me either.

Greetings and thanks.
Tom Jeffries 145 on at

Like (0)

Report

RE: How specify SSRS instance name in installation Microsoft Dynamics 365 Reporting Extensions?

Hello,

Can you create a Microsoft support case? Our engineers can help with this.

Thanks!
Suggested answer

Gary Letter 1,267 on at

Like (0)

Report

RE: How specify SSRS instance name in installation Microsoft Dynamics 365 Reporting Extensions?

Hi Business Central,

Where are you running the Reporting Extensions installation from? Try logging into the server on which SSRS is installed (usually the SQL Server). Right-click SrsDataConnector.exe and Run As Administrator.

The install program can only find a local SSRS instance. This is not the only reason the SSRS Instance drop-down might be blank, but it is a common one.

Gary Letter
NextLevel Business Systems

If you find the answer useful, please mark it as verified.