Well, I finally got it to work today. After reading everything I
could get my hands on I put the right peices together. I had to
first, give the domain user, in our case, domain\Administrator
sysadmin rights in SQL Server. I figured that one out a while ago.
Then I had to go to the Domain Security, User Rights Assigns in Active
Directory. I modified the administrator user rights assignments to
allow it to Act as part of the operating System, Increase Quotas,
Replace a proces level token, Log on as a batch job, and Log on as a
service. To make sure everything was in sync, I stopped all services,
made sure SQL Server's account was that of the
domain\Administrator...made sure that the SQL Server Agent had the
same account, rebooted SQL Server, which restarted all the services,
and voila...my scheduled jobs will now run. Thanks to all who tried
to help. I knew it had to do with permissions, but darned if I could
figure out what to do about it. Maybe this will help someone else.


phantomtoe@yahoo.com (Rowan) wrote in message news:<4bbf8d70.0404081147.67ec4d5d@posting.google. com>...
> Thanks. I had read through that article a few times. I appreciate
> your help and would love to hear your solution if you find one.
> Today, I stopped all the services, changed the sql server account to
> System and rebooted hoping that would solve my problem. It did solve
> another problem I was having with a catalog failing to populate, but
> it did not fix my package problem.
>
> Something I left out is that my scheduled backups run just fine. So I
> am wondering, if the problem is with SQL Agent permissions...wouldn't
> the scheduled backups not run either? If that is the case, then is it
> possible that the connection I am making to the AS400 is somehow not
> getting the Username and password I specified in the connection
> properties? If that could be the problem, does anybody have any
> suggestions on how I might test that or fix it? I can't think of
> anything else to try. I am out of ideas.
>
> ryanofford@hotmail.com (Ryan) wrote in message news:<7802b79d.0404080146.518ebe9d@posting.google. com>...
> > I found a reference to this when searching. It may be of help to you.
> >
> > http://support.microsoft.com/?kbid=269074
> >
> > I have a similar problem in that my DTS package runs for me (with sa
> > privileges) but I can't get it to run as a scheduled task. I've not
> > found the solution yet, but if I do, I'll post something here in case
> > it is of use.
> >
> > Ryan