I just created some SQL jobs in 2005 which points to a SSIS package. When I execute this job directly I am able to execute it just fine. However, when I execute it from the SQL Server Agent job I get this error:
Date 10/17/2007 3:01:33 PM
Log SQL Server (Current - 10/17/2007 3:01:00 PM)
Login failed for user 'TEST'. [CLIENT: <local machine>]
This login has full access rights so I am not sure why it is keep failing? Any ideas?