Reporting Error. The report cannot be displayed

Recently, I was upgrading one of our client’s SQL Server 2008 server to SQL Server 2008 R2 and got this error when testing Microsoft Dynamics CRM reports after the upgrade.

Reporting Error. The report cannot be displayed.

Try this action again, if the problem continues, check the Microsoft Dynamics CRM Community for solutions or contact your organizations Microsoft Dynamics CRM Administrator. Finally, you can contact Microsoft Support.

Additionally, the following event is logged on the CRM Server.

Source:MSCRMReporting

Event ID:19969

Web service request SetDataSourceCredentials to Report Server http://ServerName/ReportServer failed with SoapException. Error: An error has occurred during report processing. (rsProcessingAborted)

 To resolve this, uninstall and reinstall the SSRS data connector for CRM. The SSRS data connector for CRM can be downloaded from here http://www.microsoft.com/download/en/details.aspx?DisplayLang=en&id=12005. The download includes a lot of other stuff that you don’t need. After extracting the files, open up the SSRSDataConnector and run the Microsoft.crm.setup.ssrsdataconnectoe.exe file as shown in the screen shot below.

After the installation is completed, you will need to reset IIS and restart Reporting Services service.