I encountered the following issue while trying to run a report from the Service Manager console:
This was a total new installation (done by the Power Depoloyment Toolkit) and everything was installed fine without any errors so I doubled check my SQL, my datawarehouse server, my SQL reporting Service and by digging deeper and deeper into the reports themself on the SQL report I discovered the following error:
So that was the culprit! To solve this issue, open the configuration of each report, go to data sources and select the DWDataMart Data source:
click OK and now you will be able to run reports again!