Hi everybody!

 

I have a sharepoint 2013 farm with sql server 2012 installed in sharepoint integrated mode. reporting service is running on web front end server. I create reports that contains data sources from sql server tables and sharepoint lists and then put them in web page via report viewer webpart and they work properly. Now I need to filter results from sharepoint list according to report parameter value so I try to connect to sharepoint lists with xml type datasource. so I create datasource with this settings:

 

and create a dataset and set to use this data source. It can connect to sharepoint list because return lists fields but when I run the report get the following error:

Any idea?? Any solution??

• Edited by Somatco Saturday, February 15, 2014 8:00 AM

Hi Somatco,

According to your description, my understanding is that you got an error when you ran report with xml type datasource.

Please set the xml datasource credential to Use Windows Authentication (integrated security). More information, please refer to the link:

http://social.technet.microsoft.com/Forums/sqlserver/en-US/530c29ab-7ed5-4c36-816a-910c0b51f4bd/xml-data-source-unable-to-authenticate-using-windows-authentication?forum=sqlreportingservices

Here are some similar posts for you to take a look at:

http://www.symantec.com/business/support/index?page=content&id=TECH190935

http://social.msdn.microsoft.com/Forums/en-US/285e4e8c-d05c-48f8-b4f3-9d87988d823e/an-error-has-occurred-during-report-processing-rsprocessingaborted-query-execution-failed-for?forum=sqlreportingservices

In addition, as this issue is related to SQL Server Reporting, I commend you create a new thread in SQL Server Reporting forum, more experts will assist you with SQL Server Reporting.

SQL Server Report forum:

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/home?forum=sqlreportingservices

I hope this helps.

Thanks,

Wendy

Thanks dear Wendy!

When I changed xml datasource to use windows authentication (integrated) or SharePoint user I got the following error when click on Test connection:

and I think it cannot be double hop problem because I got the error on my front end server that is my reporting server too. :(

• Edited by Somatco Saturday, February 15, 2014 8:02 AM

Is the Claims to windows token service running?  Under what identity?  

Hi Somatco,

Please try to set the datasource to use Prompt for credentials, compare the result.

Please check whether the links are useful:

http://microscoff.com/2013/11/07/adfs-authentication-reporting-services-workaround/

http://social.technet.microsoft.com/Forums/sharepoint/en-US/463ad6e8-b61b-415d-a833-b10f689c0d4e/fba-ldap-ssrs-can-not-convert-claims-identity-to-windows-token-this-may-be-due-to-user-not?forum=sharepointgeneralprevious

I hope this helps.

Thanks,

Wendy

I try to use "Prompt for credentials", then test connection show connected successfully for data source but when I run the report I got following error:

:(