I have integrated ssrs 2008 and sharepoint 3.0. both are installed on same server. i have deployed a RDL report on sharepoint and when preview the report , i got the error like - >An error has occurred during report processing. (rsProcessingAborted) >Query execution failed for dataset 'DataSet2'. (rsErrorExecutingCommand) >For more information about this error navigate to the report server on the local server machine, or enable remote errors but when i am running the same report in ssrs project its not throwing error. also when i delete the that rdl from sharepoint and again deploye the issue has been resolved. can u tell me please what is exact reason behind this ?Regards, Bijay Maurya

Hi Bijay, The error "Query execution failed for dataset 'DataSet2'" occurs when The account used to connect to the data source doesn't have permissions to query the database. The credential is invalid. So, to solve the issue, please try using "Stored Credential" for the report. Or, if we are using Windows Intergrated security for the Reporting Services SharePoint Integration mode, please make sure all Service Principal Name(SPN) is registered correctly. The Reporting Services service account and the SharePoint web application pool account is enabled to delegation. I would suggest you follow this article to check the deployment, this may help to solve the issue: http://msdn.microsoft.com/en-us/library/bb326356.aspx If you have any more questions, please feel free to ask. Thanks, Jin Chen Jin Chen - MSFT