Hi, group:
I am having a problem with a DTS job that processes an OLAP cube.
The DTS package executes successfully from the DTS Designer
but when run from SQLAgent, it fails with the following error:

NOTE: my SQL Server is on computer A, while MS Analysis Services is on
another computer B.

Thank you for any input!
eilison
eilisonl (AT) yahoo (DOT) com

----------------------------------------------------
Executed as user: HJTC\HJTCSQLServer.
DTSRun: Loading...
DTSRun: Executing...
DTSRun OnStart: DTSStep_DTSOlapProcess.Task_1
DTSRun OnError: DTSStep_DTSOlapProcess.Task_1,
Error = -2147221387 (80040075)
Error string: Network error [Internal error] ''
Error source: 13IE▌
Help file:
Help context: 1000440
Error Detail Records:
Error: 0 (0);
Provider Error: 0 (0)
Error string: Network error [Internal error] ''
Error source: 13IE▌
Help file:
Help context: 1000440
DTSRun OnFinish: DTSStep_DTSOlapProcess.Task_1
DTSRun: Package execution complete.
Process Exit Code 1.
The step failed.
----------------------------------------------------

Is SQL Server Agent running under an OLAP Administrators member account ?

"eilison" <eilisonl (AT) yahoo (DOT) com> wrote

Yes, We have a domain account, and both SQL Server and Agent run under
this account. Since OLAP Administrator is a local group on the
computer where MS Analysis Services is installed, I have add that
domain account into the local group.

So far, I guess the core of my problem lies on the security.

Thank you!
eilison
eilisonl (AT) yahoo (DOT) com



"Francesco Anti" <fanti (AT) sicosbt (DOT) it> wrote