"TroyS" <troy.stauber@ilg.com> wrote in message
news:eUfItwmqFHA.2604@TK2MSFTNGP14.phx.gbl...
>I have a package that executes just fine when i select 'execute'
> When i go to schedule it, the corresponding job is created. But when i run
> the job, it fails. It says: "Cannot connect to the Analysis server on
> computer 'ENG1SQLV1'. Connection to the server is lost Error
> source: DSO"
>
> is this an issue with the job component of sqlserveragent?
>
> The package simply makes a server connection, runs a sp to extract/build a
> table, runs an analysis services full process on a cube. The package, the
> sp and analysis services are all on the same database server though sql
> server is clustered.
>
> any ideas would be helpful. thx.
>

"Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
news:%23VQIBbtqFHA.3604@tk2msftngp13.phx.gbl...
> This article invariably helps when a package runs interactively but not as
> a job.
>
> http://support.microsoft.com/?kbid=269074
>
>
> "TroyS" <troy.stauber@ilg.com> wrote in message
> news:eUfItwmqFHA.2604@TK2MSFTNGP14.phx.gbl...
>>I have a package that executes just fine when i select 'execute'
>> When i go to schedule it, the corresponding job is created. But when i
>> run the job, it fails. It says: "Cannot connect to the Analysis server
>> on computer 'ENG1SQLV1'. Connection to the server is lost Error
>> source: DSO"
>>
>> is this an issue with the job component of sqlserveragent?
>>
>> The package simply makes a server connection, runs a sp to extract/build
>> a table, runs an analysis services full process on a cube. The package,
>> the sp and analysis services are all on the same database server though
>> sql server is clustered.
>>
>> any ideas would be helpful. thx.
>>
>
>

"PS" <PS@discussions.microsoft.com> wrote in message
news:22C2C021-7FE8-459C-8749-26D722FB6E9D@microsoft.com:

> Hi,
> I'm currently experiencing the same issue that you have just desribed.
> I
> would really appreciate it if you could point me in the right direction.
> Have checked OLAP administrators, etc.
> Thanks a lot!
>
> "TroyS" wrote:
>
>
> > I have a package that executes just fine when i select 'execute'
> > When i go to schedule it, the corresponding job is created. But when i
> run
> > the job, it fails. It says: "Cannot connect to the Analysis server on
> > computer 'ENG1SQLV1'. Connection to the server is lost Error
> source:
> > DSO"
> >
> > is this an issue with the job component of sqlserveragent?
> >
> > The package simply makes a server connection, runs a sp to
> extract/build a
> > table, runs an analysis services full process on a cube. The package,
> the sp
> > and analysis services are all on the same database server though sql
> server
> > is clustered.
> >
> > any ideas would be helpful. thx.
> >
> >
> >