We are trying to run a report which uses a xml file to load a report on SSRS.
We have copied the xml to the Pages folder and are able to access the xml via the link
This runs fine in the report designer.(i,e we are able to get create xml data source and use a dataset to retrieve the data from xml to the report designer)
However when I try to create a XML datasource on the development server and try to run the report , we get the following error
An error occurred during client rendering.
An error has occurred during report processing.
Query execution failed for dataset 'DataSet1'.
Failed to execute web request for the specified URL. Unauthorized: The remote server returned an error: (401) Unauthorized.
The remote server returned an error: (401) Unauthorized.
I have updated the XML datasource to use Windows Account which is in the adminstrators group.
Any suggestions or hints are appreciated
View Complete Post