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
