SSRS: Error While running reporting from MOSS 2007
Hi,
I am trying to run a customized report uploaded on report manager from MOSS 2007 thru a report view web part. The report is working properly from the report manager and display normaly, when i am trying to access it form the report view
webpart am getting the following errors:
An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for dataset 'Branch'. (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
Please noting that am using the same admin username for SSRS and MOSS 2007, and they are installed on a different server.
any help, thanks in advance
November 1st, 2012 5:16am
Hi ,
can you run the report through URL in IE in the remote server?
hope the following link will help you.
http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/a8ce234f-dffc-46ed-8b88-5de4f8626ac1
Free Windows Admin Tool Kit Click here and download it now
December 3rd, 2012 6:13am