Hi everyone
I have SSRS database integrated with a SharePoint farm. I have created a report and uploaded the report to a SharePoint Document library. The report works fine in Visual Studio and is successfully deployed to the document library. But when I run the report from the Document Library I get the following error:
An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for dataset 'DataSet1. (rsErrorExecutingCommand)
Failed to execute web request for the specified URL. Unauthorized: The remote server returned an error: (401) Unauthorized. (rsXmlDataProviderError)
For more information about this error navigate to the report server on the local server machine, or enable remote errors
Apparently this is a security issue. I don’t know where to configure this. The dataset in the report has valid credentials, so this cannot be the problem.
If anyone has any solution I appreciate your help
Thanks