Reporting Error: Error while fetching data extension

Resolution – You might use either of the below two solutions or both:

  

1)      SQL Server Reporting Service is not running on server. 

Check SQL Server Reporting Service for its status. Start the service if its already not running. Follow these steps:

ü  Start > Administrative Tools > Services

ü  Right click SQL Server Reporting Service > Properties > Start

ü  Check SQL Reporting Services URL for the Organization

2)      The SQL Report Server URL must have been configured incorrectly

Follow below steps to resolve:

ü  Open Deployment Manager

ü  Disable the Organization for which Reports are not running

ü  Click Edit Organization

ü  Check Report Server URL is correct or not. If it is not correct, update the Report Server URL. It might be of the kind http://crmsrv:5555/ReportServer

ü  Follow the wizard further and click Finish

ü  Enable the CRM Organization

* To know the correct URL for Report Server, open Reporting Services Configuration Manager and click on Web Service URL and check the URL towards the below of dialog window.