Getting error below when try to run inport job automatically.

Job saved in MSDE on WinXP box.
Importing from SQL2000 on Win2000 Server.

I can execute the job manually OK.

SQLAgent on importing MSDE logging on as system account.

Any help would be appreciated.

Thanks.

Alan

--------------------------------------------------------
Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description:Unable to connect to source server for Transfer.
(Microsoft SQL-DMO (ODBC SQLState: 28000) (80004005): [Microsoft][ODBC SQL
Server Driver][SQL Server]Login failed for user 'NT AUTHORITY\ANONYMOUS
LOGON'.)
Step Error code: 80040443
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:5700

If the MSDE box where the job is located is running under
the local system account then you won't be able to import
from a different server. The local system account does not
have access to network resources including other servers.

-Sue

On Wed, 4 May 2005 14:14:55 -0400, "Alan Z. Scharf"
<ascharf (AT) grapevines (DOT) com> wrote:

Sue,

Thanks very much for your reply.

I will have to rearrange things.

Alan

"Sue Hoegemeier" <Sue_H (AT) nomail (DOT) please> wrote