Can't Schedule DTS package - Access Denied
Posted on 2004-09-07
Win 2000 SP4 SQL 2000 SP3 - I have created a cube etc and am really happy - only to get totally frustrated by the fact I can't schedule the damn thing. I have created a local package which executes fine but when it's scheduled I get this error:
executed as user: LOWEA\Administrator. The process could not be created for step 1 of job 0xD2AE7FFDBB6F5844AAF4051ED4B461E5 (reason: Access is denied). The step failed.
Have looked high and low for a solution and followed an Article from MS about usual DTS security issues
but the LOWE\Administrator profile as quoted above is the account that starts all the SQL services and the account the server is currently logged on with.
I have spent ages b uilding complex dimensions and cubes to fufill a project and can't believe that I am stuck on the final hurdle - if the thing did not work at all great but the fact I can execute it just not autmoate the execution is driving me nuts .....