Hi Guys,
I have a report which consume Web Service. When I run the report from SSRS Server Url, it can run. But when I deployed to CRM, I've got this error.
When I trace it from SSRS Log file, I've got this error:
library!ReportServer_0-1!23ec!06/22/2018-10:56:15:: w WARN: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.DataExtensions.XmlDP.XmlDPException: The data extension supports Windows Integrated Security and No Credentials (anonymous request) only.
at Microsoft.ReportingServices.DataExtensions.XmlDPConnection.set_UserName(String value)
at Microsoft.ReportingServices.Diagnostics.DataExtensionConnectionBase.HandleImpersonation(IProcessingDataSource dataSource, DataSourceInfo dataSourceInfo, String datasetName, IDbConnection connection, Action afterImpersonationAction)
at Microsoft.ReportingServices.Diagnostics.DataExtensionConnectionBase.OpenDataSourceExtensionConnection(IProcessingDataSource dataSourceObj, String connectString, DataSourceInfo dataSourceInfo, String datasetName)
at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSource.OpenConnection(DataSource dataSourceObj, DataSet dataSetObj, OnDemandProcessingContext pc, DataProcessingMetrics metrics)
at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSource.OpenInitialConnectionAndTransaction()
at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSource.InitializeDataSource()
at Microsoft.ReportingServices.OnDemandProcessing.RuntimeAtomicDataSource.Process(Boolean fromOdp)
I know this happened because of security issue. I tried to change the report to no credential, used predefined user, setup Unattended Execution Account. But none of this one works.
Can you help me?
