Post reply

Configure Account to Run Job

  • September 11, 2006 at 1:38 pm

    #174156

    Hello,

    How can I set up sufficient premissions for a SQL account to run a Job without making the account a System Administrator?

    I am trying to troubleshoot what I think is a permissions problem (to a network share addressed in a DTS package) with the following in mind;

    "When the user is not a member of the sysadmin fixed server role, sp_start_job will impersonate the SQL Server Agent proxy account, which is specified using xp_sqlagent_proxy_account."

    Thank you for your help!

    CSDunn

     

  • September 11, 2006 at 2:21 pm

    #659762

    The account that runs SQL Agent needs to have appropriate permission on the network folder.It does not have to be "sysadmin" role it can be "processadmin".

     

  • September 12, 2006 at 1:45 am

    #659809

    The Proxy account enables the non-sysadmins to run the command line utilities and run ActiveScripting job steps. To configure it, go to the properties of SQL Agent and then go to 'Job System' tab. Here, uncheck 'Only users with SysAdmin priviledges can execute CmdExec and ActiveScripting jobs steps.' You will be prompted for the user name, password and domain you wish to act as Proxy account. Enter the details and press OK.

    Pankaj

    Pankaj Khanna
    Database Administrator - SQL Server 2000

    Keep hope to keep you intact...

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

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