June 2, 2003 at 1:45 pm
I have a few DTS Packages on SQL 7 w/ SP1 that I can execute work but when schedule as jobs they all failed. I have alter btween enabling Non-SysAdmin to only SysAdmin to execute jobs on the SQL Agent but after changing back and forth I get this error msg:
[000] Password verification of the 'SQLAgentCmdExec' proxy account failed (reason: A required privilege is not held by the client)
The account that start SQL Services is a domain account with 'local\admin' and 'sys admin.' If you know the problem, please advise. Thanks in advance...
June 2, 2003 at 10:12 pm
The SQLAgentCmdExec account is the Proxy account that is being refered to, it is used as the NT authenticated login for scheduled jobs not owned by SA. If you have Service pack > 2 you should be able to select an option to reset proxy account and reset proxy account password. (Think these are from SQLAgent Properties) As another test to ensure this account has enough permissions check the NT acocunt SQLAgentCmdExec and add it to local administrators group, this should give it access from the builtin\admins login.
June 3, 2003 at 9:13 am
First, my mistake for not putting this in the DTS Forum.
I used an NT account that has both NT local admin and SQL sys admin. I were able to reset proxy account and password w/o error. However, after making the change and restart SQL Agent, from SQL Agent Error log I got the msg:
[000] Password verification of the 'SQLAgentCmdExec' proxy account failed (reason: A required privilege is not held by the client).
But if i don't want to use the non-SysAdmin account to execute jobs, I still get the same error. So basically I can't schedule a DTS package but my other jobs such as backup run fine. Anyone have any ideas what is the problem? thanks..
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply