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