Can a SQL Express Report Server use an MSDE database as a datasource?
Posted on 2009-07-12
I've setup a 2008 EXPRESS Reporting Services Server. The same server also has MSDE installed. The MSDE database holds all the data for the Reporting.
I'm having problems generating the reports using a data source linked to the MSDE.
I've checked the permissions, security and tried re-deploying the reports and manually editing the data source for each report.
Is this a compatible feature? I've tried the same reports using 2008 database as the datasource and it worked fine. The error I get with the MSDE database is:
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'TrendDataSource'. (rsErrorOpeningConnection)
The report server has encountered a configuration error. (rsServerConfigurationError)