RS OLAP Connection Problem

I have a stand alone win2k3 reporting services server(i.e. SQL is not on the
box). RS SP1 is installed.
I have a SQLRS report developed in visual studio (on the same box) that runs
MDX against an analysis services cube. I am using the OLE DB provider for
OLAP services 8.0. (Note that we had to run ptsfull.exe on the reporting
services server to get the pivot table service and 8.0 provider to be
available)
I can successfully connect to Analysis Services and preview the report in
visual studio.
When I run the report in Report Manger, the report bombs with...
An error has occurred during report processing. (rsProcessingAborted)
Get Online Help
Cannot create a connection to data source 'ServerNameBlahBlah'.
(rsErrorOpeningConnection) Get Online Help
Database 'CubeNameBlahBlah' does not exist.
I have a AS database role setup that should allow the stored
credentials to successfully authenticate.
HELP !!!!That is what you get when you don't have rights to the AS datasource. Open
Visual Studio Report Designer by right-clicking and choosing "Run as" and
choose the same credentials you are using as stored credentials for the AS
datasource. See if you can then preview the report, you will probably get a
similar error.
--
Douglas McDowell douglas@.nospam.solidqualitylearning.com
"James" <carbonc@.carbonc.com> wrote in message
news:e8X%231pbJFHA.3928@.TK2MSFTNGP09.phx.gbl...
>I have a stand alone win2k3 reporting services server(i.e. SQL is not on
>the
> box). RS SP1 is installed.
> I have a SQLRS report developed in visual studio (on the same box) that
> runs
> MDX against an analysis services cube. I am using the OLE DB provider for
> OLAP services 8.0. (Note that we had to run ptsfull.exe on the reporting
> services server to get the pivot table service and 8.0 provider to be
> available)
> I can successfully connect to Analysis Services and preview the report in
> visual studio.
> When I run the report in Report Manger, the report bombs with...
> An error has occurred during report processing. (rsProcessingAborted)
> Get Online Help
> Cannot create a connection to data source 'ServerNameBlahBlah'.
> (rsErrorOpeningConnection) Get Online Help
> Database 'CubeNameBlahBlah' does not exist.
> I have a AS database role setup that should allow the stored
> credentials to successfully authenticate.
>
> HELP !!!!
>

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