After successfully installing and processing the IT Analytics (ITA) cubes, some reports fail to load. The errors returned are:
An error has occurred during report processing. (rsProcessingAborted)Cannot create a connection to data source 'ITAnalyticsEmbedded'. (rsErrorOpeningConnection)
Version: 2.9.1
Component: Reporting Services
An incorrect data source is defined for the report(s) in the Reporting Services Web Portal.
Manually re-assign the data source of the affected reports to the default data source ITAnalytics by following this procedure: