After spending a few hours I’ve figured out what exactly should I do to install this glorious SSRS CRM Data Connector (Microsoft Dynamics CRM Reporting Extensions) on SQL Server 2017.
These Extensions were for Microsoft Dynamics CRM 2011 but I’m sure you can use this method for CRM 2016 and 365 too.
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:WindowsMicrosoft.NETFrameworkv4.0.30319InstallUtil.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.
* In [HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL ServerInstance NamesRS] branch add new REG_SZ attribute with name ‘MSSQLSERVER’ and value ‘SSRS’
* In [HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL ServerSSRSSetup] 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 complete successfully.
5. Manually restart SSRS using stop and start buttons in Report Server Configuration Manager.
6. Finally, check in the /Reports web application. Open any data source and check that a new data source type options have appeared.
