Post reply

Job Failing due to Server access permissions

  • July 14, 2009 at 5:26 pm

    #206974

    Hello,

    I have a simple job that imports an excel spreadsheet from a share drive to a database on a 2005 server, and then renames the file.

    Obviously when I run the package from within BIDS it works, however when I export the package to the MSDB on the server and schedule it, the package does not work.

    The error is:

    The job failed. The owner (HNEAHS\SThornton) of job Import_Westpac_Bankstatement does not have server access.

    My account has permissions on both servers, so I am wondering what actual permissions are required to get this to run. I know I can probably change the job owner to the SA account and it'll work, but why doesn't my account work?

    Thanks,

  • July 14, 2009 at 5:40 pm

    #1024781

    HI,

    Nevermind. My account had become disconnected from the domain overnight.

Viewing 2 posts - 1 through 1 (of 1 total)

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