Issue

The following error is encountered while running reports from the Reports section in CRM

clip_image001

“Error occurred while fetching the list of data extensions installed on the report server.”

Resolution

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:

clip_image002

Go to Organizations. Select the Organization that relates to the instance where the issue is encountered.

clip_image003

After selecting the Organization, click on Disable

clip_image005

Confirm selection

clip_image006

Confirm that the Organization has a Status of Disabled

Select the Organization and click on Edit Organization…

clip_image007

Update the SQL Server Reporting Services URL with the correct URL. Click Next

clip_image008

Click Next to validate configuration

clip_image009

Click Apply to confirm changes

clip_image010

Re-enable the Organization by selecting it and clicking on Enable

clip_image007[1]

Confirm selection

clip_image011

Validate the changes by logging in to the CRM instance, and running a report.

Enjoy!

Advertisements