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 |
|
Surfer513
Starting Member
29 Posts |
 Posted - 2011-03-09 : 11:16:30
|
| I'm having an issue that I can't seem to get past. I have a executable file that runs with no issues. But when I put it in a batch file (there are other tasks to be completed as well) and set the SQL job to run the batch file, I get an Access Denied error. I don't understand the problem, and the directory has every possible right so I don't believe it's a file system security issue.Any ideas??Thanks in advance. :) |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-03-09 : 21:28:25
|
| Give SQL Agent servicew account permissions on the exe, and whatever resources the exe accesses. |
 |
|
|
|
|
|
Running a SQL Job - Access Denied