Thursday, May 28, 2015

vRealize configuration Manager - unable to run reports

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