Monday, March 12, 2012

Reporting Service with Analysis service

I compose two servers. One is for Reporting service and the other is for
Analysis Service. I developed one report with analysis services's cube as a
datasource.
but the report does not execute properly. the message is for datasource
connection error.
So I compose the server again as one server. The RS ans AS installed in this
server.
The report works properly!
Is it impossible to install at seperate server ?
I used SQL server 2000 with current sevicepack.Hey,
It does work with 2 different servers. You may be having issues with
authentication or permissions.
If possible use an admin account from Analysis server in the connection
properties of the datasource.
Bye
Sumit Pilankar
"fogcity" <fogcity@.discussions.microsoft.com> wrote in message
news:FA13FF31-94D4-4619-8E9B-212252B372EF@.microsoft.com...
>I compose two servers. One is for Reporting service and the other is for
> Analysis Service. I developed one report with analysis services's cube as
> a
> datasource.
> but the report does not execute properly. the message is for datasource
> connection error.
> So I compose the server again as one server. The RS ans AS installed in
> this
> server.
> The report works properly!
> Is it impossible to install at seperate server ?
> I used SQL server 2000 with current sevicepack.
>

No comments:

Post a Comment