Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-09-09 : 09:15:20
|
| Shaminda Fernando writes "I have a DTS package on a SQL Server 2000 and I can run the DTS package without any problem. I can even execute it at a different client machine other than mine. But when I schedule it, the job fails. Every job I created so far has failed. I have admin rights to the server, so I have full access to the server. Has anybody seen this problem before? Below is the detailed error message I get. I even checked Microsoft Knowledge Base Article - Q269074. But this article doesn't make sence, because in actuality if I have God rights to that sever how come I cannot schedule jobs? DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: Drop table F3JTPJITA Step DTSRun OnError: Drop table F3JTPJITA Step, Error = -2147217843 (80040E4D) Error string: Login failed for user '\'. 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 '\'. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 DTSRun OnFinish: Drop table F3JTPJITA Step DTSRun OnStart: Create Table F3JTPJITA Step DTSRun OnError: Create Table F3JTPJITA Step, Error = -2147217843 (80040E4D) Error string: Login failed for user '\'. 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 . The step failed." |
|
|
pucci70
Starting Member
20 Posts |
|
|
|
|
|
Cannot Schedule jobs 