Hi,
I get the following error when trying to execute a cube via a dts
package when i run it from a remote server that has the sql server tools
installed, but no server, and analysis manager installed. Does anyone know
what I have done wrong?

I am running SQL Server 2000 Sp3a on the database server and MS Server 2000
on the database server and MS Server 2003 on the remote server.

Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.

C:\Documents and Settings\PrdInform>dtsrun /s adlsqlrpt /n ml_test /e
DTSRun: Loading...
DTSRun: Executing...
DTSRun OnStart: DTSStep_DTSOlapProcess.Task_1
DTSRun OnError: DTSStep_DTSOlapProcess.Task_1, Error = -2146828218 (800A0046)
Error string: The remote server has been paused or is in the process of
bein
g started.

Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 700

Error Detail Records:

Error: -2146828218 (800A0046); Provider Error: 0 (0)
Error string: The remote server has been paused or is in the process of
bein
g started.

Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 700


Error: -2147467259 (80004005); Provider Error: 0 (0)
Error string: Permission denied
Error source: DTSOlapProcess
Help file:
Help context: 1000070

DTSRun OnFinish: DTSStep_DTSOlapProcess.Task_1
DTSRun: Package execution complete.

Seems like a security issue to me. Verify that the user that the DTS package
is running under has rights to process the cube on the MSAS server.
--
Keith Mescha


"John" wrote: