Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Analysis Server and Reporting Services (2005)  An error occurred during report processing

Author  Topic  co-dba Starting Member 2 Posts Posted - 2010-06-04 : 13:57:19 I am working on a reporting services system that was restored from a previous system that failed. Getting reporting services reconfigured has not been completely successful. The error I cannot get past is: * An error has occurred during report processing. o Query execution failed for data set 'dataset'. + Invalid object name 'objectName'. I have fixed orphan users, set up the RSExecRole in master, msdn, ReportServer and ReportServerTempDb The authentication is set to Windows integrated security for the data source I have made sure that the Windows user has a login id, is a member of the RSExecRole in every DB The reports run just fine in Visual Studio on the server The version Running is SQL Server 2005 I have completely run out of things to try and have exhausted every post I can find on the subject. Any help is greatly appreciated.