Hello Everyone, Please help me with following problem.
I have scheduled a DTS package and get error "Login failed for user 'NT
AUTHORITY\ANONYMOUS LOGON". This package runs properly when I'm running
manually.

For details See below
BAGS 'N BAGS OF THANKS
Raj
(local)Executed as user: CCMOLAPDEV01\SYSTEM. ...t:
DTSStep_DTSExecutePackageTask_1 DTSRun OnError:
DTSStep_DTSExecutePackageTask_1, Error = -2147217843 (80040E4D) Error
string: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Error
source: Microsoft OLE DB Provider for SQL Server Help file: Help
context: 0 Error Detail Records: Error: -2147217843 (80040E4D);
Provider Error: 18456 (4818) Error string: Login failed for user 'NT
AUTHORITY\ANONYMOUS LOGON'. Error source: Microsoft OLE DB Provider for
SQL Server Help file: Help context: 0 DTSRun OnFinish:
DTSStep_DTSExecutePackageTask_1 DTSRun OnStart:
DTSStep_DTSExecutePackageTask_2 DTSRun OnError:
DTSStep_DTSExecutePackageTask_2, Error = -2147217843 (80040E4D) Error
string: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Error
source: Microsoft OLE DB Provider for SQL Server Help file: Help
context: 0 Error... Process Exit Code 9. The step failed.

http://www.support.microsoft.com/?id=269074 How to Run a DTS Package as a
Scheduled Job


--
Andrew J. Kelly SQL MVP


"Raj Tripathi" <Raj Tripathi (AT) discussions (DOT) microsoft.com> wrote