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 2005 Web Parts

I am using the SQL 2005 Reporting Services web parts within a WSS site.
SQLRS uses IIS virtual smtp server for delivery which works fine.
Using the report explorer web part, when I setup a subscription, the
value in the To: field defaults to the uneditable <username> rather
than a full mail address (username@.somewhere.com).
Is there a way to change this behavior such that the To: field displays
the full maill address instead?
Thanks!You can't make the UI show the host name, but you can make the server apply
a host name if one is not present. In the RSReportServer.config file, in
the element DefaultHostName, set your hostname and all address which do not
have a host name will get the value in this field.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jim" <emailjeffp@.yahoo.com> wrote in message
news:1136576961.392050.65820@.g44g2000cwa.googlegroups.com...
>I am using the SQL 2005 Reporting Services web parts within a WSS site.
> SQLRS uses IIS virtual smtp server for delivery which works fine.
> Using the report explorer web part, when I setup a subscription, the
> value in the To: field defaults to the uneditable <username> rather
> than a full mail address (username@.somewhere.com).
> Is there a way to change this behavior such that the To: field displays
> the full maill address instead?
> Thanks!
>