Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rohans
Posting Yak Master
194 Posts |
 Posted - 2004-02-17 : 10:58:01
|
| I am getting the following error a sql server in the SQLAGENT.out file in the logs. Any idea how to correct this?2/16/2004 7:29:27 AM - ! [000] Password verification of the 'SQLAgentCmdExec' proxy account failed (reason: A required privilege is not held by the client)All help appreciated. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-02-17 : 12:38:39
|
From SQL Server Books Online:quote:
How to reset SQLAgentCmdExec permissions (Enterprise Manager)To reset SQLAgentCmdExec permissions Expand a server group, and then expand a server.Expand Management, right-click SQL Server Agent, and then click Properties.Click the Job System tab.Under Non-SysAdmin job step proxy account, clear the Only users with SysAdmin privileges can execute CmdExe and ActiveScripting job steps check box, and click Reset Proxy Account. Type the user name, password, and domain of the user account to be used by SQL Server Agent when running jobs owned by users who are not system administrators.
Tara |
 |
|
|
rohans
Posting Yak Master
194 Posts |
Posted - 2004-02-18 : 12:02:34
|
| The buttons on my server for Reset Proxy Password and Reset Proxy Account are greyed out. What does this allow? Does it tighten security by allowing a minimum account to do the SQL jobs and no need for a Local System admin account that has more authority?All help appreciated. |
|
|
|
rohans
Posting Yak Master
194 Posts |
Posted - 2004-03-04 : 11:26:39
|
| Maybe I need to add that this is SQL7All help appreciated. |
|
|
|
|
|
|
SQLAgentCmdExec password