The following error is encountered while running reports from the Reports section in CRM
“Error occurred while fetching the list of data extensions installed on the report server.”
This issue is caused by the following configuration: the current CRM instance is not pointing to the correct Reporting Server URL.
In order to correct this, from the CRM server, launch Deployment Manager:
Go to Organizations. Select the Organization that relates to the instance where the issue is encountered.
After selecting the Organization, click on Disable
Confirm that the Organization has a Status of Disabled
Select the Organization and click on Edit Organization…
Update the SQL Server Reporting Services URL with the correct URL. Click Next
Click Next to validate configuration
Click Apply to confirm changes
Re-enable the Organization by selecting it and clicking on Enable
Validate the changes by logging in to the CRM instance, and running a report.
Leave a Reply