Post reply

DTS Job issue.

  • September 25, 2008 at 8:26 am

    #194147

    Hello,

    I use SQL Server 2000. I have a DTS job that is scheduled to run once daily. The problem is that it fails with this error.

    "Executed as user: MIS-SERVER\SYSTEM. The process could not be created for step 1 of job 0xC73D4A78D15F6646B6284FF39C618CDE (reason: Access is denied). The step failed. " It runs fine if I run this manually.

    I know the error message sounds like the issue is one of permissions, but I don't know what needs to be done to fix it.

    Could someone please help me with this?

    thanks.

  • September 25, 2008 at 8:58 am

    #877074

    Can you give us a bit more information?

    What to Step 1 do?

    What permissions does the reported account have on that instance of SQL? On that server?

    Is that the account that SQL Server Agent runs under?


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • September 25, 2008 at 9:01 am

    #877076

    Hi,

    SQL server start up account is 'system account'. Is that 'sa'? DTS package is owned by MIS-Server/Administrator; Scheduled job is owned by 'sa'

    Thanks.

  • September 25, 2008 at 9:09 am

    #877085

    Hi,

    Here is the answer to your questions.

    What to Step 1 do? ===> Step 1 runs a SQL Script that copies some data from Informix to SQL Server.

    What permissions does the reported account have on that instance of SQL? On that server? ===> You mean on Informix? Could you please clarify?

    Is that the account that SQL Server Agent runs under? ===> SQL Server account runs under 'system account'. Is that sys Admin?

    Thanks.

  • September 25, 2008 at 3:19 pm

    #877363

    When you run the DTS manually, are you using a different account than the one that starts the SQL Agent?

    The account that starts the SQL Agent is what the job runs under and must have rights to where the data is coming from (Informix) and where it's going (SQL Server).

    _____________________________________________________________________
    - Nate

    @nate_hughes

  • September 26, 2008 at 7:59 am

    #877706

    When I run the job manually, I login using sysadmin and just run the job.

    The account that starts SQL Server agent is 'LocalSystem'. I can change the permission on server logins to this particular login, but I don't see a 'LocalSystem' login there - I have BUILTIN\Administrators, master, masterRO,NT AUTHORITY\SYSTEM and sa as logins there. So, which one do I change here?

    I appreciate your help.

    thanks.

  • September 26, 2008 at 8:15 am

    #877732

    I think that in order to resolve your problem you're gonna have to create a network account for SQL Server and/or SQL Server Agent to use instead of the local system account.

    You can then assign to this account that it needs to access the other server. I don't believe you can do that to the local system account, because it's local.


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • September 29, 2008 at 9:51 am

    #878477

    Hi,

    This issue is now fixed. Thank you for your help.

Viewing 8 posts - 1 through 7 (of 7 total)

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