|
Home > Archive > MS SQL Server DTS > October 2005 > Error while running a scheduled a DTS package
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Error while running a scheduled a DTS package
|
|
| Raj Tripathi 2005-10-27, 7:57 am |
| 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_DTSExecutePa
ckageTask_1 DTSRun OnError:
DTSStep_DTSExecutePa
ckageTask_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_DTSExecutePa
ckageTask_1 DTSRun OnStart:
DTSStep_DTSExecutePa
ckageTask_2 DTSRun OnError:
DTSStep_DTSExecutePa
ckageTask_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.
| |
| Andrew J. Kelly 2005-10-27, 7:57 am |
|
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@discussions
.microsoft.com> wrote in message
news:542AC785-4F00-418F-8762- 4030F15C3103@microso
ft.com...
> 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_DTSExecutePa
ckageTask_1 DTSRun OnError:
> DTSStep_DTSExecutePa
ckageTask_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_DTSExecutePa
ckageTask_1 DTSRun OnStart:
> DTSStep_DTSExecutePa
ckageTask_2 DTSRun OnError:
> DTSStep_DTSExecutePa
ckageTask_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.
|
|
|
|
|