CODEWITHSUNDEEP
reporting-servicesdynamics-crm-2016sql-server-2017
Nasir
Nasir

Reputation: 207

CRM reporting Extension - SSRS instance is blank

Trying to install Reporting Extension for CRM 2016 but SSRS instance is blank.

VM containing (SQL & CRM on the same machine)

Can you please help me how to fix the error below (SSRS instance name is empty). Can we install reporting extension on SQL server 2017 (should be OK as I was able to install CRM server)?

enter image description here

Upvotes: 5

Views: 7720

Answers (3)

Bruce Nadeau
Bruce Nadeau

Reputation: 1

I have followed the steps... Added the SSRS via the NSSM / Kibana steps I discovered. Started the SSRS services and they are running, created the two Registry keys as shown above, reran my SetupSrsDataConnector.exe via the .exe itself and not via the GUI for Dynamics, I now SEE the SSRS "entry" and select next BUT then I error out on the check... "Unable to validate SQL Server Reporting Services Report Server installation. Please check that it is correctly installed on the local machine."

I ASSUME the instance is is due to creating a fake SSRS instance to be selected... I have been stuck on this for nearly TWO days. Please advise,

Upvotes: 0

Milan Hettner
Milan Hettner

Reputation: 137

1) Download nssm util - https://nssm.cc/download

2) Unzip nssm.exe and copy to windir (c:\windows)

3) Run cmd as administrator and then command : nssm install ReportServer$SSRS c:\windows\notepad.exe

4) Start service ReportServer$SSRS ( net start ReportServer$SSRS )

5) Open registry HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\SSRS\Setup and add REG_SZ attribute with name Version and value '14.0.600.1572' (SSRS version)

6) Install crm connector (SetupSrsDataConnector.exe)

7) Install latest patch for crm convertor (greather then 0.3) - https://support.microsoft.com/en-us/help/3142345/microsoft-dynamics-365-onpremise-cumulative-updates (CRM9.0-Srs-KBXXXXXX-ENU-Amd64.exe)

8) Restart server

9) Stop service ReportServer$SSRS ( net stop ReportServer$SSRS )

10) Remove dummy service : nssm remove ReportServer$SSRS confirm

11) Optional - delete nssm.exe from windows directory

Upvotes: 5

user12012052
user12012052

Reputation: 21

Search for CRM reporting Extension - SSRS instance is blank.

  1. Make sure that in the Report Server Configuration Manager there is specified a service account which is a member of PrivReportingGroup and has a write permissions to this group. This account must not be a member of SQLAccessGroup. At least during installation.
  2. The setup program also needs a windows service names exactly 'ReportServer$SSRS'. To achieve this, just create a dummy blank new service with a specified name and register it using C:\Windows\Microsoft.NET\Framework\v4.0.30319\InstallUtil.exe
  3. After that, we need to open Regedit.exe to make changes that will allow the setup program to discover and validate our SSRS instance.
    1. In [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\RS] branch add new REG_SZ attribute with name 'MSSQLSERVER' and value 'SSRS'
    2. In [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\SSRS\Setup] branch add new REG_SZ attribute with name 'Version' and value '14.0.600.906' (in my case, you should use your version of SQL server)
  4. Now run the setup program (SetupSrsDataConnector.exe). Some next step must show our SSRS instance and we choose it. After all the steps done we will get the last step with important System Checks which all must be green, thanks to our preparation actions.

Voilà! Setup completed successfully.

  1. Manually restart SSRS using stop and start buttons in Report Server Configuration Manager.
  2. Finally, check in the /Reports web application. Open any data source and check that a new data source type options have appeared

Upvotes: 2

Related Questions