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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-03-24 : 18:04:54
|
| ståle writes "Hello.I'm trying to implement the xp_cmdshell command in a trigger. But it only works then I'm logged on as an sysadmin account. I read something about an xp_sqlagent_proxy_account that had to be present for the xp_cmdshell to impersonate the SQL Server sysadmin account - but I can't find anywhere to create or modify this account. In the Enterprise Manager, under Management - SQL Server Agent - properties - Job System, I found a setting for allowing all users to run xp_cmdshell. but this doesn't change anything even though I restarted both the SQL-server and SQL-server-agent.Does anyone have an answer to this?" |
|
|
scottpt
Posting Yak Master
186 Posts |
Posted - 2002-05-06 : 10:56:48
|
| Make sure the SqlAgentCmdExec account has the following permissionsAct as part of the operating systemIncrease quotasreplace processes level token log on as a batch job |
 |
|
|
|
|
|
xp_cmdshell without sysadmin account