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