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 |
|
davele
Starting Member
1 Post |
 Posted - 2008-09-16 : 12:52:52
|
| When running the xp_cmdshell I am getting an error"The network path was not found."This works fine from a query window, but does not work from a SQL Server Agent Job.SQL Server is configured to run as the domain administrator (which has access to the folder it is trying to access).I ran a whoami /all to confirm that the job is actually running as the administrator.This is driving my crazy.Any clues? I've been all over the net looking for answers.Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2008-09-16 : 13:01:35
|
| I'm not certain but...I think that if a non-admin account launches the job, then any xp_cmdshell calls will not run as the sql server service account but rather will run under the xp_cmdshell_proxy_account. Even if the job owner is a sysadmin.Be One with the OptimizerTG |
 |
|
|
|
|
|
xp_cmdshell