Issue with SSRS connector in SQL 2017 environment + Dynamics crm 9.0

(0) Share

Report

Posted on by CRM Queries

We had working environment of Dynamics CRM 9.0 and SQL 2016.

Recently we have updated SQL server to 2017. After that SSRS data connector is giving issues. We are unable to create new org or import.

Tried to repair SSRS data connector but is is giving “Unable to validate SQL server reporting Report server installation” error.

Please suggest solution to this. how to make ssrs data connector workable.

Options tried: 1. Added Reporting service account to Privereporting Group.

2. Created 2 registry keys

In [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\RS] branch add new REG_SZ attribute with name 'MSSQLSERVER' and value 'SSRS'
In [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\SSRS\Setup] branch add new REG_SZ attribute with name 'Version' and value "14.0.1000.169".

3. Restarted Reporting service.

But still SSRS data connector is not recognising.

Please help to find solution to this.

I have the same question (0)