When trying to run reports we receive the following error:
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source ‘ECM’. (rsErrorOpeningConnection)
For more information about this error navigate to the report server on the local server machine, or enable remote errors
Troubleshooting:
Login to data source on report server to verify authentication which was successful
Worked with VMware support on solution
Solution:
add basic to the end of the AuthenticationTypes string in the rsreportserver.config file of the report server.
C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer