Can't connect to data source

I've got a report (2005) that is sourcing from an AS2000 cube. Everything works fine in the BI Dev Studio, it builds and deploys without a hitch. The report has a shared data source and is using a generic login (i.e. it's not set to my NT login).

However, when I navigate to the Report Server and try to run the report, I get the following error message...

Cannot create a connection to data source

On the Report Server, I'm using the same credentials that I used in BIDS. I've tried a number of Connection Types and I've copied the Connection String from BIDS to the Report Server, but still no luck.

Any clues? I'm kind of at a loss.

UPDATE...I've just created a very vanilla report where the data source is on the same box as my previously mentioned report, and it worked. The only difference is that this vanilla report is using a SQL Db as the source and not an AS cube.

Are there special security concerns when sourcing from a cube?

|||

After the report is deployed to the report server, edit the data source properties of the report and store credentials in the report server database (instead of e.g. using integrated security which won't work unless you have Kerberos delegation enabled).

Also, check the report server logfiles for more information on the error returned from the AS data provider. It may help to determine why the connection fails.

-- Robert

|||

Yeah, I've got the 'credentials stored on server' option checked for the data source.

I've checked the logs and the errors say ...

Cannot create a connection to data source 'PCR_Source'. > System.Data.OleDb.OleDbException: Database 'AHL_PCR' does not exist.

The cube located in the AS db 'AHL_PCR' has been processed (and, I can source from it just fine in BIDS), so I'm not sure why I'm getting this message.