Sunday, 3 July 2011

An error has occurred during report processing. (rsProcessingAborted)

When running SQL Reporting Services Reports deployed for Dynamics GP 2010 we receive the error:

"An error has occurred during report processing. (rsProcessingAborted)

Cannot create a connection to data source 'DataSourceGPCompany'. (rsErrorOpeningConnection)"
 
Resolution:
As the SQL Server Reporting Services service is on a different server to the database server we could not use the Windows authentication for the datasources.  To correct amend each datasource (one per company and one for Dynamics database), and mark each to use SQL Server authentication.  Use a SQL login to with sufficent rights

1 comment:

  1. HI Michael
    I have installed Business Portal 5.1 recently and am getting "An error has occurred during report processing. (rsProcessingAborted) on nearly every single page in the Executive Center. Also get errors similar to this: "An error has occurred during report processing. (rsProcessingAborted)
    Cannot create a connection to data source 'DataSourceGPCompany'. (rsErrorOpeningConnection)
    Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'". Can you please help to resolve?

    ReplyDelete