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
No comments:
Post a Comment