all groups > sql server new users > june 2005 >
You're in the

sql server new users

group:

SQL Agent Account


Re: SQL Agent Account Helge C. Rutz
6/27/2005 12:00:00 AM
sql server new users: Hi Gabe,

[quoted text, click to view]

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
SQL Agent Account Gabe Matteson
6/27/2005 12:11:52 PM
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

AddThis Social Bookmark Button