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