RS and OLAP (Database not found)

I tried to use Analysis Services with Reporting Services and all worked fine, when I'm within the VS IDE. But when I upload the rdl to my Reporting Server and execute the report I got an exeption "database ... not found".
I have 1 server with IIS and Reporting Services and 1 server with SQL 2000 and Analysis Services installed.
I there anybody who can help me ?
Many thanks
PeterPeter,
I am having a similar problem. I have RS on one server and AS on a
different server. I have not been able to figure out how to pass the
appropriate credentials from RS to the AS server.
In your solution was RS and As on the same server?
Thanks,
Blaine
"PNeuwi" wrote:
> We solved the problem by adding roles to the OLAP-Database and using this user for the connect. We stored the user information to the report server and used it as windows credentials.
> Peter|||Blaine,
I am having the same problem. Were you able to find a solution?
"Blaine" wrote:
> Peter,
> I am having a similar problem. I have RS on one server and AS on a
> different server. I have not been able to figure out how to pass the
> appropriate credentials from RS to the AS server.
> In your solution was RS and As on the same server?
> Thanks,
> Blaine
> "PNeuwi" wrote:
> > We solved the problem by adding roles to the OLAP-Database and using this user for the connect. We stored the user information to the report server and used it as windows credentials.
> >
> > Peter|||Did you find a solution? I read another article that said something about
setting SSPI=Kerberos on the datasource.
Steve
"George Kousis" wrote:
> Blaine,
> I am having the same problem. Were you able to find a solution?
> "Blaine" wrote:
> > Peter,
> >
> > I am having a similar problem. I have RS on one server and AS on a
> > different server. I have not been able to figure out how to pass the
> > appropriate credentials from RS to the AS server.
> > In your solution was RS and As on the same server?
> >
> > Thanks,
> >
> > Blaine
> >
> > "PNeuwi" wrote:
> >
> > > We solved the problem by adding roles to the OLAP-Database and using this user for the connect. We stored the user information to the report server and used it as windows credentials.
> > >
> > > Peter