Can a SQL Express Report Server use an MSDE database as a datasource?

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)

Who is Participating?
rob_farleyConnect With a Mentor Commented:
Yeah, it sounds like it. SSRS Express is only designed for reporting on the local instance.

MSDE is an in-process database, so you use it differently.

And... SSRS 2008 Express will only allow the local data source. I'm not sure if it's considering MSDE a separate system or not, or whether the problem is related to MSDE being in-process and not particularly compatible with SSRS on the whole

I know it's a pain, I'm sorry I'm not helping more here. Can you sync the MSDE into a SQL Express database and then use that? There really shouldn't be a problem that way, and syncing should be easy enough too.

wint100Author Commented:
I've tried connecting remotley from 2008 Ent to the MSDE and this works fine. So maybe it's more of a limitation of Express SQL.

I'll do some tests today and post back.
wint100Author Commented:
You were right, the express version doesn't allow a datasource to connect to another instance. Strange how they didn't bother to add a message to say that was the error.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.