backup problem

Hello,

This backup plan i have that works fine when i trigger it manually does not work when scheduled, here is the output of the error I am getting, I am new to sql 2005 and i really need to get this working fast, and dont have alot of time to research the problem right now.

Tdar

Error Message:

05/12/2007 00:00:01,daily backup.Subplan_1,Error,1,IPDDFZ2363ATL2,daily backup.Subplan_1,Subplan_1,,Executed as user: IPDDFZ2363ATL2\MSSQL_USER. ...42.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 12:00:01 AM Error: 2007-05-12 00:00:20.92 Code: 0xC00291EC Source: {C4C38724-5AEF-4472-9CC9-E24587B74591} Execute SQL Task Description: Failed to acquire connection "Local server connection". Connection may not be configured correctly or you may not have the right permissions on this connection. End Error Warning: 2007-05-12 00:00:20.93 Code: 0x80019002 Source: OnPreExecute Description: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded<c/> but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors. End Warning Error: 2007-05-12 00:00:21.51 Code: 0xC0024104 Source: Back Up Database (Full) ... The package execution fa... The step failed.,00:00:20,0,0,,,,0
05/11/2007 00:00:00,daily backup.Subplan_1,Error,0,IPDDFZ2363ATL2,daily backup.Subplan_1,(Job outcome),,The job failed. The Job was invoked by Schedule 3 (BACKTEST). The last step to run was step 1 (Subplan_1).,00:00:15,0,0,,,,0

Typically, when you are able to run something (espeically DTS) by hand but it fails to work when you schedule it, it is a permissions issue. Check to see which user the job is running under and give that user the permission to execute what needs to be executed.

Tim