We have an Access 2007 database that is used as a datasource for a SSRS report. When previewing the report in Visual Studio, the report renders fine. When trying to run the report from Reporting Services, we get the following error: An error has occurred during report processing. Cannot create a connection to data source 'CapitalNotes'. For more information about this error navigate to the report server on the local server machine, or enable remote errors.
We have tried Windows Authentication, No Credentials and Credentials stored securely in the report server. Same error every time.
We have moved the database to the Reporting Services server to see if it was a permissions issue with the database since it was sitting in a folder not accessible to everyone, but still get the same error.
Any advice or suggestions would be appreciated. We are assuming it is a permissions issue, but can't figure out where we are going wrong.
We have tried Windows Authentication, No Credentials and Credentials stored securely in the report server. Same error every time.
We have moved the database to the Reporting Services server to see if it was a permissions issue with the database since it was sitting in a folder not accessible to everyone, but still get the same error.
Any advice or suggestions would be appreciated. We are assuming it is a permissions issue, but can't figure out where we are going wrong.