Instructions for Updating the Reporting Server URL

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 selection

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

Confirm selection

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

Enjoy!