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 |
|
pug2694328
Posting Yak Master
166 Posts |
 Posted - 2007-09-17 : 15:18:20
|
| I'm trying to setup a proxy user account on sql server 2000 so that non sysadmins can run xp_cmdshell. Before I try to using the account as a proxy for other users, I tried just logging in under the proxy userid/pwd and running the xp_cmdshell procedure and I'm hitting this error:xp_cmdshell failed to execute because CreateProcessAsUserW returns error 1314. please make sure the service account SQL Server running under has appropriate privilege. For more information, search Book Online for topic related to xp_sqlagent_proxy_accounMsg 50001, Level 1, State 0I gave the proxy user execute rights on master..xp_cmdshell.I made sure the user had the "Log on as a batch job" user right.I DID NOT make the user a sysadmin.Any thoughts? I followed this documentation:http://support.microsoft.com/kb/890775 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-18 : 23:59:17
|
| What kind of dos command did you run in xp_cmdshell? What's sql service account? |
 |
|
|
pug2694328
Posting Yak Master
166 Posts |
Posted - 2007-09-19 : 09:20:37
|
| exec master..xp_cmdshell 'dtsrun /S DB_NAME /N DTS_NAME /E' |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-19 : 23:54:49
|
| Is sql service account a member of sysadmin? |
|
|
|
|
|
|
xp_cmdshell proxy config