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
> >
>
>

Connection ADOMD

The problem occur when we use ADOMD to create a Cube in an ASP.NET 2.0 application with impersonate and Windows Authentication active in web.config and Integrated Security in the MSOLAP connection to the Analysis Services 2000. When we list de catalogs from Analysis Services we get authenticated with the impersonated Windows Account, but when we try to Create a new cube on a catalog, we get authenticated with the ASPNET windows account, even with impersonate set to true. We are using the 9.0 client version of MSOLAP provider to connect to an Analysis Services 2000 (8.0).

HI,thiago:

I believe this topic is related to theSQL Server Analysis Services. Now we have not this section in the forum, but here is the better place you can post your thread in and there are more experts will be glad to help you to solve your problem:

http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=83&SiteID=1

Connecting two cubes

I am using SSAS 2005 and I have a situation where I have two different cubes that I need to link up so that I can get related data from one cube to the other.

Here's the scenario:
I have a customer cube that gives me metrics about how many new customers, inactive customers, etc based on date ranges and other criteria. What I need to be able to do is once I have a subset of customers I want to be able to look at related measures that belong to a different cube. I have thought about making a large cube that contains multiple fact tables and allows me to grab both measures as necessary. The reason I'm trying to avoid this approach is because the customer data is going to be changing (a customer becomes inactive) and will require a full process on the customer cube. There are currently only about 100K customers, so the reprocess time is fairly minimal. The related data has several 100 million rows requiring a siginificant time to fully process. So, it isn't practical to have it all in the same cube where everything would have to be reprocessed. So, my questions are: Can I link two cubes together (sort of like virtual cubes in AS 2000) so that I can follow information across two cubes? Or if I did include a second fact table in the cube can I only process the fact table related to customer information and not the one containing the related data?

Thanks!

You should be able to create a 2nd measure group for the 2nd fact table in the original cube, but only process the 1st measure group:

http://msdn2.microsoft.com/en-us/library/ms175634.aspx

>>

...

Processing a Measure Group

When you process a measure group, Analysis Services processes some or all of the partitions within the measure group, and any unprocessed dimensions that participate in the measure group. Specifics of the processing job depend on the processing option that you select. You can process one or more measure groups in Analysis Services without affecting other measure groups in a cube.

Note:
You can process individual measure groups programmatically, or by using SQL Server Management Studio. You cannot process individual measure groups in Business Intelligence Development Studio unless you do so by partition. ... >>