Re: SQL Agent Proxy Account

From: Gabe Matteson (gmatteson_at_inquery.biz.nospam)
Date: 06/24/05

  • Next message: Hari Prasad: "Re: Get List of users in a sql server role" 
    Date: Fri, 24 Jun 2005 14:18:14 -0400

    The account that is running the sql agent service is a server administrator
    under SQL 2000.

    "Gabe Matteson" <gmatteson@inquery.biz.nospam> wrote in message
    news:evJfVeOeFHA.1328@TK2MSFTNGP12.phx.gbl...
    >A problem occurred while attempting to logon as the Windows user
    >'SQLAgentCmdExec': The parameter is incorrect. The step failed.
    >
    > There are a few jobs that developers create and they run under there
    > accounts, I do not want to give them sysadmin access, but they need
    > permissions to CmdExec. I enabled the SQL Agent Proxy account yet the
    > above error appears in the job after it runs. Any ideas? Thanks,
    > - Gabe
    >

  • Next message: Hari Prasad: "Re: Get List of users in a sql server role"

    Relevant Pages

    • Re: Permissions on Scheduled Jobs
      ... but you have to modify certain "shipped" items from MS. ... > I have a few Jobs that are current owned by the SQL Agent ... > Administrator account. ...
      (microsoft.public.sqlserver.security)
    • Re: Very Very Urgent, Please Help
      ... production servers services will always run under domian admin account. ... It sounds like you are running the SQL Agent service under the local ... system account which does not have access to the DTS packages. ...
      (microsoft.public.sqlserver.datawarehouse)
    • RE: dts package error
      ... "Donna Lambert" wrote: ... > under the context of the SQL Agent account. ... > account and try to manually kick off the package. ...
      (microsoft.public.sqlserver.dts)
    • RE: dts package error
      ... under the context of the SQL Agent account. ... account and try to manually kick off the package. ... > When it runs through the scheduler it cannot find the mdb file on the server. ...
      (microsoft.public.sqlserver.dts)
    • RE: xp_sqlagent_proxy_account
      ... If no reboot is needed (because the LOGONSERVER is set to a Domain ... Verify that the startup account for SQL Server and SQL Agent services have ...
      (microsoft.public.sqlserver.security)