SQL Server Performance

Error Processing Report!

Discussion in 'SQL Server 2005 Reporting Services' started by dtaitt, Mar 20, 2007.

  1. dtaitt New Member

    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.
  2. dtaitt New Member

    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.
  3. dtaitt New Member

    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'.

Share This Page