RE: Package fails when run from Sql Server Agent

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Mohamed Sharaf (Mohamed.Sharaf_at_egdsc.microsoft.com)
Date: 12/08/04 

Date: Wed, 08 Dec 2004 10:28:49 GMT

I think you need to check the identity of the SQL Server Agent (by opening
SQL Server Agent properties) and change the identity with user that have
access on both the SQL server table (inside the database) and the MDB file
(file system)
HTH.

Regards,
Mohamed Sharaf
MEA Developer Support Center
ITWorx on behalf Microsoft EMEA GTSC

Relevant Pages

  • Re: Autostart MS Agent on Win98/Me
    ... If you really rely on SQL Server Agent being started and you have not a lot ... > with Entreprise manager and the agent start with WinNT... ... I can manually start the agent with the MSDE service manager, ...
    (microsoft.public.sqlserver.msde)
  • Re: Can MSDE run SQL Server Agent service in Win98
    ... >> SQL Server Agent service. ... > AFAIK the SQL Server Agent runs on Win9x with no problem..... ... > run as a service becouse Win9x does not support it, ...
    (microsoft.public.sqlserver.msde)
  • RE: DTS Package fails when Scheduled
    ... Make sure SQL Server Agent account has the correct rights/permissions. ... scheduled job under this context, I still received the error, even though I ...
    (microsoft.public.sqlserver.dts)
  • Re: Error running DTS package on a schedule (only!)
    ... Right Click on the SQL Server Agent icon in EM and choose properties. ... > How do I determine which account was used to start SQL Agent? ... >> | When I try to schedule a job for this DTS package under SQL Server ...
    (microsoft.public.sqlserver.dts)
  • Re: Win 2003 upgrade
    ... Then I would start it up SQL Server agent and see if I can't identify the ... For the problem with the retention period of expiring subscribers, ... 'The subscription has not been synchronized within the maximum ...
    (microsoft.public.sqlserver.replication)