Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Consuming Rest Service...
Microsoft Dynamics CRM (Archived)

Consuming Rest Service in SSRS Report, got error The data extension supports Windows Integrated Security and No Credentials (anonymous request) only.

(0) ShareShare
ReportReport
Posted on by Temmy Wahyu Raharjo 2,914

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?

*This post is locked for comments

  • Verified answer
    Temmy Wahyu Raharjo Profile Picture
    Temmy Wahyu Raharjo 2,914 on at
    RE: Consuming Rest Service in SSRS Report, got error The data extension supports Windows Integrated Security and No Credentials (anonymous request) only.

    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.

    6330.setting.PNG

    Thanks

  • Verified answer
    PranavShroti Profile Picture
    PranavShroti 4,510 on at
    RE: Consuming Rest Service in SSRS Report, got error The data extension supports Windows Integrated Security and No Credentials (anonymous request) only.

    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...

    stackoverflow.com/.../crm-2011-ssrs-report-using-non-fetchxml-data-source-in-sub-report

    Regards,

    Pranav

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Microsoft Dynamics CRM (Archived)

#1
Mohamed Amine Mahmoudi Profile Picture

Mohamed Amine Mahmoudi 83 Super User 2025 Season 1

#2
Community Member Profile Picture

Community Member 52

#3
dkrishna Profile Picture

dkrishna 6

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans