Instructions for Updating the Reporting Server URL

 

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!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

A WordPress.com Website.

Up ↑

%d bloggers like this: