Post reply

DTS Sch. Job Fails -doesn't exist or access denied

  • April 15, 2003 at 7:53 am

    #357744

    I have DTS package scheduled to run with Agent. It runs AOK manually but fails if done through agent. The failure message I get is "SQL Server Does Not Exist or Access Denied" I understand this is probably a permissions issue. What permissions should the SQL Server Services Agent have? Should it be in the System Administrators Group? We have NT 4

  • April 15, 2003 at 11:48 am

    #454280

    I'm guessing the user that runs the SQL Server Agent doesn't have access to one of the connections in the DTS Package. Check if the logon account for the SQL Server agent has access to all databases. See BOL topic "Handling Package Security in DTS" Also, was a "user" password created when the DTS package was saved?

    Darren


    Darren

  • April 16, 2003 at 9:45 am

    #454390

    Hi cross,

    Check here.... DTS schedule problem

    http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q269074

  • April 17, 2003 at 10:04 am

    #454580

    Thanks for the advice and the link - The NT account that runs Agent is a member of the SQL Server sysadmin role and is member of the NT System Administrators group. I read the article - very helpful in explaining details. I checked on things the article said to check on and found no problems. I did more testing and found that another, less complicated package will run OK when scheduled. Maybe it is a problem with just the one.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply