Re: DTS fails on job but runs manually

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Costa,

When executed by the SQL Agent your DTS package runs as the local admin account. When you run it, it runs as your login. Therefore, your login has rights to something that the local admin account does not.

Note that the local admin account is "local" and is not good for accessing files on the network, other servers, and so forth. A DTS package is often making use of resources outside the machine where the SQL Server runs.

Recommendation: Your SQL Server should not be running as local admin, but as a domain account that has been granted the needed rights on the SQL Server as well as other domain rights that are necessary to your job.

RLF


"Socrates" <Socrates@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:1B260D47-CD2C-4D5E-8894-CB9D37619101@xxxxxxxxxxxxxxxx
All,

My package is failing on the sqlagent jobs but run successfully when
executed manually. The package was created using the local admin login which
is under the sql built-in admin account so I'm not sure why its failing for
the job.

Thanks for your help.

Costa


.

Relevant Pages

  • RE: local admin account password
    ... Subject: local admin account password ... 5)My main idea/plan is to store all the passwords on a central SQL server. ... There would be basically two stored procs, ...
    (Focus-Microsoft)
  • Re: Users
    ... To change sa login do I connect via an ODBC connection - and is an account with local admin on my machine would accomplish that change. ... What type of access would you allow network engineers to have in sql, the main functionality is a network back up they run and include SQL in that. ...
    (microsoft.public.sqlserver.server)
  • RE: local admin account password
    ... The script randomises the local admin password at every boot and stores ... Use a different password on all boxes and a big filling cabinet to secure ... Only use domain accounts so delete the local ones. ... 5)My main idea/plan is to store all the passwords on a central SQL server. ...
    (Focus-Microsoft)
  • Re: Installation problem
    ... I checked the sql log most of the times it says user logged in successfully ... I am trying to configure biztalk and got the following error: ... (User being sa, local admin on BizTalk server, part of SSO ... created and the error didn't occur until the configuration started on ...
    (microsoft.public.biztalk.general)
  • RE: local admin account password
    ... Do you think if someone wanted to break the local admin account they ... more recovery console and don't think cached logins will work. ... 5)My main idea/plan is to store all the passwords on a central SQL server. ...
    (Focus-Microsoft)