Job Failing due to Server access permissions

• Scott Thornton-407727

  SSCrazy

  Points: 2271

  More actions

  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,

• Scott Thornton-407727

  SSCrazy

  Points: 2271

  More actions

  July 14, 2009 at 5:40 pm

  #1024781

  HI,

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