Report connect to AS cube

I cannot get my report to connect to my datacube. I've got RS running on a
web server and Analysis Services running on another server. The two servers
have an established relationship as i am currently able to run RS reports
against the SQL Server relational db's that exist on the server that is
running AS.
When i try to execute a report against a cube i get "cannot connect to the
server {myserver}. the server is either too busy or not started".
The connection string i am using is:
Provider=MSOLAP.2;Client Cache Size=25;Data Source={myserver};Auto Synch
Period=10000;Initial Catalog={mycatalog}
This all works fine in my dev environment where AS and RS run on the same
server.
What extra step am i missing to get my RS Web server to talk to my AS DB
server?
Thanks for any info.Sorry i do not know the answer for your question. But i am facing one
problem.I am unable to get the query designer, to type the MDX query to get
reports from my analysis server. I am using the Analysis server and web
server on the same machine.
When i am trying to create the report using SQL server relational db, i
am able to get the query designer. Please help me..
Dhar.
"JeffW" wrote:
> I cannot get my report to connect to my datacube. I've got RS running on a
> web server and Analysis Services running on another server. The two servers
> have an established relationship as i am currently able to run RS reports
> against the SQL Server relational db's that exist on the server that is
> running AS.
> When i try to execute a report against a cube i get "cannot connect to the
> server {myserver}. the server is either too busy or not started".
> The connection string i am using is:
> Provider=MSOLAP.2;Client Cache Size=25;Data Source={myserver};Auto Synch
> Period=10000;Initial Catalog={mycatalog}
> This all works fine in my dev environment where AS and RS run on the same
> server.
> What extra step am i missing to get my RS Web server to talk to my AS DB
> server?
> Thanks for any info.
>|||Dahr:
I was able to solve my problem. Turns out, port 2725 was not open between
my web and db servers. once i opened up that port everything runs fine.
As for your issue, if you are running version 1 of RS with sp1, it does not
support an mdx query designer. i believe that capability is scheduled for
the next release of Reporting services. For now, you just have to type the
mdx in, or use another mdx builder to get the query you need, and then
copy/paste it into rs.
Hope that helps.
JeffW
"Dhar" wrote:
> Sorry i do not know the answer for your question. But i am facing one
> problem.I am unable to get the query designer, to type the MDX query to get
> reports from my analysis server. I am using the Analysis server and web
> server on the same machine.
> When i am trying to create the report using SQL server relational db, i
> am able to get the query designer. Please help me..
>
> Dhar.
>
> "JeffW" wrote:
> > I cannot get my report to connect to my datacube. I've got RS running on a
> > web server and Analysis Services running on another server. The two servers
> > have an established relationship as i am currently able to run RS reports
> > against the SQL Server relational db's that exist on the server that is
> > running AS.
> >
> > When i try to execute a report against a cube i get "cannot connect to the
> > server {myserver}. the server is either too busy or not started".
> >
> > The connection string i am using is:
> > Provider=MSOLAP.2;Client Cache Size=25;Data Source={myserver};Auto Synch
> > Period=10000;Initial Catalog={mycatalog}
> >
> > This all works fine in my dev environment where AS and RS run on the same
> > server.
> >
> > What extra step am i missing to get my RS Web server to talk to my AS DB
> > server?
> >
> > Thanks for any info.
> >
> >

Report Builder Connection Error

Okay, here is the scenario. I have an analysis services cube and a report
model generated from a OLAP datasource in reporting services. My first
problem is that when I try to create a report using the report builder from
my local pc I get data source connection errors, but if I remote desktop into
the dev server where reporting services is installed an complete the same
procedure everything works great. My second problem is that I cannot create
a report model from an OLAP datasource unless I am remoted into the report
server.
Thanks, Andrewwhen you create report model, you need to use default in your data source
properties, so that it takes the same and connects.
second problem is: have you deployed your report model, only then you can
see the entities and then you can create the reports.
Amarnath
"chabotwvu" wrote:
> Okay, here is the scenario. I have an analysis services cube and a report
> model generated from a OLAP datasource in reporting services. My first
> problem is that when I try to create a report using the report builder from
> my local pc I get data source connection errors, but if I remote desktop into
> the dev server where reporting services is installed an complete the same
> procedure everything works great. My second problem is that I cannot create
> a report model from an OLAP datasource unless I am remoted into the report
> server.
> Thanks, Andrew|||When I navigate to my OLAP datasource using SQL Server Management Studio and
generate the model my datasource security is set to windows integrated
security. The OLAP datasource impersonation information is set to use the
service account; when I do this from SSMS on my local laptop I get connection
errors, but if I remote desktop into the reporting services server and
connect to reporting services using the SSMS it will create the model and you
can create and run a report from the report builder no problem.
"Amarnath" wrote:
> when you create report model, you need to use default in your data source
> properties, so that it takes the same and connects.
> second problem is: have you deployed your report model, only then you can
> see the entities and then you can create the reports.
> Amarnath
>
> "chabotwvu" wrote:
> > Okay, here is the scenario. I have an analysis services cube and a report
> > model generated from a OLAP datasource in reporting services. My first
> > problem is that when I try to create a report using the report builder from
> > my local pc I get data source connection errors, but if I remote desktop into
> > the dev server where reporting services is installed an complete the same
> > procedure everything works great. My second problem is that I cannot create
> > a report model from an OLAP datasource unless I am remoted into the report
> > server.
> >
> > Thanks, Andrew|||Here is the error message from the Report Server Log Files:
e ERROR: Throwing
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException:
Cannot create a connection to data source 'dataSource1'., ;
Info:
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException:
Cannot create a connection to data source 'dataSource1'.
--> Microsoft.AnalysisServices.AdomdClient.AdomdConnectionException:
The connection either timed out or was lost. --> System.IO.IOException:
Unable to read data from the transport connection:
An existing connection was forcibly closed by the remote host. -->
System.Net.Sockets.SocketException: An existing connection was forcibly
closed by the remote host
"chabotwvu" wrote:
> When I navigate to my OLAP datasource using SQL Server Management Studio and
> generate the model my datasource security is set to windows integrated
> security. The OLAP datasource impersonation information is set to use the
> service account; when I do this from SSMS on my local laptop I get connection
> errors, but if I remote desktop into the reporting services server and
> connect to reporting services using the SSMS it will create the model and you
> can create and run a report from the report builder no problem.
> "Amarnath" wrote:
> > when you create report model, you need to use default in your data source
> > properties, so that it takes the same and connects.
> >
> > second problem is: have you deployed your report model, only then you can
> > see the entities and then you can create the reports.
> >
> > Amarnath
> >
> >
> > "chabotwvu" wrote:
> >
> > > Okay, here is the scenario. I have an analysis services cube and a report
> > > model generated from a OLAP datasource in reporting services. My first
> > > problem is that when I try to create a report using the report builder from
> > > my local pc I get data source connection errors, but if I remote desktop into
> > > the dev server where reporting services is installed an complete the same
> > > procedure everything works great. My second problem is that I cannot create
> > > a report model from an OLAP datasource unless I am remoted into the report
> > > server.
> > >
> > > Thanks, Andrew

Report Builder and Analysis Services 2000

Hi,

Quite simple question: Is it possible to use Report Builder when using Analysis Services 2000 cubes as data source?

/SuneSounds like it will.
http://msdn.microsoft.com/SQL/2005/2005Webcasts/ReportingServicesQandA.aspx|||

Analysis Services 2000 cubes are not supported.