Personalized Community is here!
Quickly customize your community to find the content you seek.
Have questions on moving to the cloud? Visit the Dynamics 365 Migration Community today! Microsoft’s extensive network of Dynamics AX and Dynamics CRM experts can help.
2022 Release Wave 2Check out the latest updates and new features of Dynamics 365 released from October 2022 through March 2023
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
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?
First thing to check will be the current user identity
When you run from outside what user identity it is picking (I believe it will be logged in windows user) and when CRM is running?
check below thread as well: if that works for you...
Thanks, found the root cause already after examined the ReportServer1 - 3 and found out that the report id is different when I run local and from CRM. Then I try to delete and create new report and changed the setting into use current windows users.
Business Applications communities