Connection error to As 2000 cube data source

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
DonAre the cubes on the same domain with your report server?
If not, it won't connect.
"Don" <Don@.discussions.microsoft.com> wrote in message
news:26BEED36-14C5-48A1-87DA-E751CB391888@.microsoft.com...
> 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
> Don
>|||Chris,
Thanks for the quick response. Yes, my OLAP server and Report Server on the
same domain, and my domain user account on both boxes.
"Chris" wrote:
> Are the cubes on the same domain with your report server?
> If not, it won't connect.
> "Don" <Don@.discussions.microsoft.com> wrote in message
> news:26BEED36-14C5-48A1-87DA-E751CB391888@.microsoft.com...
> > 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
> >
> > Don
> >
>
>