connect to AS2000 cube error

Here is my setup: I have Reporting Service and SQL Server 2000 in one box
(Box A), and IIS and Analysis Service in another box (Box B), which has
couple of cubes based on the database in Box A, using SQL Authentication and
Allow save password. Create AS2000 data source at Reporting Project, then
create a report, I can preview the report fine in VS.2003. But I got the
following error after deploying the report to the reportserver and browse the
report:

Cannot create a connection to data source 'Cube'. (rsErrorOpeningConnection)
Get Online Help
Database 'Cube' does not exist.
Do I miss anything?

Thanks

Reporting services and Analysis Services only support Windows authentication.

Another problem with your setup is that even if you use windows authentication you cannot validate users between to servers without using Kerberos and account delegation.

Its possible to use standalone servers and maintain the same windows accounts on the separate machines manually.

Regards

Thomas Ivarsson

sqlsql