Re: SQL Agent Account

From: Helge C. Rutz (news050424_at_nurfuerspam.de)
Date: 06/27/05 

Date: Mon, 27 Jun 2005 18:50:46 +0200

Hi Gabe,

"Gabe Matteson" wrote:
>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.

when you enable the proxy account, you have to specify a windows account
with password - what did you entered there?.
Please check this account if it is allowed to login locally, and try to
execute cmdExec as a non sysadmin user.

Helge

Relevant Pages

  • Unable to reset SQL agent proxy account
    ... account for SQL server service account, ... and SQL Agent proxy account. ...
    (microsoft.public.sqlserver.security)
  • Re: Why I use a Mac, anno 2006
    ... (must trim followups... ... no such account exists on Windows ... The typical windows user is logged in an administrator ...
    (comp.sys.mac.advocacy)
  • Re: SQL Agent Proxy Account
    ... The account that is running the sql agent service is a server administrator ... >A problem occurred while attempting to logon as the Windows user ... > There are a few jobs that developers create and they run under there ...
    (microsoft.public.sqlserver.security)
  • Re: Timesheet questions
    ... those two or resource accounts to Project Server authentication rather than ... Windows User Account authentication. ... with the person's Project Server user name and password. ... features require Windows User Account authentication for resources to be ...
    (microsoft.public.project.pro_and_server)
  • Re: MSDE connection problem
    ... >account with enought privileges to performs it's ... that means that running MSDE was not restricted by ... If i was logged in by the restricted windows user account ...
    (microsoft.public.sqlserver.msde)