web
You’re offline. This is a read only version of the page.
close
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) / Dynamics Crm 2011: Web...
Microsoft Dynamics CRM (Archived)

Dynamics Crm 2011: Web service request GetDataSources to Report Server failed. Error: The request failed with HTTP status 401

(0) ShareShare
ReportReport
Posted on by MoMo 430

I am getting this very weird error with my reports "Web service request GetDataSources to Report Server failed. Error: The request failed with HTTP status 401".

Server A is Active Directory

Server B is SQL Server 2008 R2 with Reporting Services

Server c is CRM 2011 Application Server. 

PLEASE HELP ME!! I am being struggling with this problem since weeks and weeks.

*This post is locked for comments

I have the same question (0)
  • Demian Rashkovan Profile Picture
    Demian Rashkovan 130 on at

    Maybe this helps you: social.msdn.microsoft.com/.../web-service-request-getdatasources-to-report-server-httpsreportserver-failed-with

    i have same problema and with this i resolved:

    Aye - one of the things that MSCRM does when you upload an RDL file is look for the connection string in the report and replace it, which rules out using SRS Datasource objects.

    The plus point to this is that you do not need to edit your Report between different MSCRM Environments as MSCRM will manage this when you upload the RDL file.

    The negative point is this prevents you from using SRS Datasources, you must use a fixed connection string in the report itself such that the report is self-contained and not reliant on a separate Datasource object - otherwise you encounter an error on uploading the report to MSCRM.

    You probably need to remove the Datasources from your Reporting Project, and give each report in the project it's own connection string to MSCRM by modifying the Dataset to use a connection string instead of a Datasource.

    Hope that helps.

  • Community Member Profile Picture
    Community Member on at

    Hello,

    Does the error occur for all reports(including default reports) or only custom reports?

    What is the update rollup installed on CRM Server and Reporting server ?

    Does the error occur when the report is run in SRS directly?

    What is the error message that you see in the CRM UI ?

    Any errors logged in event viewer on both CRM and SQL related to this issue ?

    Does the issue occur for all users?

    Check the SRS logs which would give more details about this issue from the below path :

    %programfiles%\Microsoft SQL Server\<SQL Server Instance>\Reporting Services\LogFiles

    Thank You.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans