Error Processing Report! | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Error Processing Report!

General Users get an error message when trying to access any reports we have created.
All admin have no problems with the reports. Users (Domain Users) are given rights (Browser) to the reports and the Data Sources (Browser) and yet cannot view the reports. An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source ‘DS2’. (rsErrorOpeningConnection)
For more information about this error navigate to the report server on the local server machine, or enable remote errors This is a SQL 2005 (Windows 2003 Server) box.
I’ll add this from the report logs…
w3wp!processing!1!3/20/2007-11:43:25:: e ERROR: Data source ‘DS2#%92: An error has occurred. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source ‘DS2#%92. —> System.Data.SqlClient.SqlException: Cannot open database “Database” requested by the login. The login failed.
Login failed for user ‘DOMAINUsername#%92.
w3wp!processing!1!3/20/2007-11:43:25:: e ERROR: An exception has occurred in data source ‘DS2#%92. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source ‘DS2#%92. —> System.Data.SqlClient.SqlException: Cannot open database “Database” requested by the login. The login failed.
Login failed for user ‘DOMAINUsername#%92.
w3wp!processing!1!3/20/2007-11:43:25:: i INFO: Merge abort handler called. Aborting data sources …
w3wp!processing!1!3/20/2007-11:43:25:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing., ;
Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. —> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source ‘DS2#%92. —> System.Data.SqlClient.SqlException: Cannot open database “Database” requested by the login. The login failed.
Login failed for user ‘DOMAINUsername#%92.
The user has rights via a local group to the report and data source (Browser rights) and the local group has been added as a SQL login.
Ok, I gave rights to the databases themselves instead of just to SQL and the error changed (Ah-ha…progress, but why!?!?) The new error message: An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for data set ‘TestID’. (rsErrorExecutingCommand)
For more information about this error navigate to the report server on the local server machine, or enable remote errors The log file reads: —> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set ‘TestID’. —> System.Data.SqlClient.SqlException: SELECT permission denied on object ‘TableID’, database ‘Database’, schema ‘dbo’.
]]>