Tuesday, December 8, 2020

SSRS in blank while setting up D365 Srs Reporting extention

 While setting up srs connector for Dynamics 365 (for SQL 2017) the SSRS instance was blank.

check all things

1. installing this component in right server, means in the server where report server was installed : it is correct

2. account is correct

finally found below article https://stackoverflow.com/questions/50265735/crm-reporting-extension-ssrs-instance-is-blank , helped me

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

No comments:

Post a Comment