SQL Agent Account

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

Date: Mon, 27 Jun 2005 12:11:52 -0400

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. The account that is running the sql
agent service is a server administrator
under SQL 2000.
Any ideas? Thanks,
- Gabe

Relevant Pages

  • Re: Jobs Failed do not work when scheduled done via DTS Scheduled Package
    ... the SQL info out within the PATH. ... running one of the Jobs and it executed without a hitch. ... > What does the DTS package do? ... the account used is whatever account you ...
    (microsoft.public.sqlserver.server)
  • Re: Rights Change to Administrator Account Causes Hassles
    ... Administrator login account? ... SQL Server Agent services? ... > from the Administrator login account. ... All the jobs run as self. ...
    (microsoft.public.sqlserver.security)
  • Re: Change service account with SQL server 2000 sp4
    ... I deleted the builtin administrator as systemadminstrator. ... It is a AD domain account. ... I then changed all SQL jobs to the new account. ...
    (microsoft.public.sqlserver.security)
  • Re: Rights Change to Administrator Account Causes Hassles
    ... I want to remove the SQL sysadmin rights from the NT Administrator login ... As to the "why," besides my goal of tightening up SQL ... Currently all services run under the "local" account. ... Most of the jobs are maintenance plan jobs, ...
    (microsoft.public.sqlserver.security)
  • Re: sql problem
    ... Account # is the link field on ... The requirement is I have to come up with a report comparing the two ... customer tables to see if they are in sync. ... what I wanted to do was to get the SQL to return the "like" names ...
    (comp.databases.oracle.server)