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 |
|
justinlong24
Starting Member
1 Post |
 Posted - 2008-04-17 : 10:25:45
|
| Hello,Here is what I have. I have created a DTS package that runs an SFTP process through a batch file. The DTS package works when I execute it. When I turn it into a job, it fails, it cannot connect to the server that I am trying to connect to. The job runs under under the SQLSERVERAGENT service. That account is started using a username and password that is part of the SYSADMIN group. The owner of the job is a user that is part of a Domain, but has admin priveledges. Not sure where to go from here. Any kind of advice would be helpful. Thank you |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-17 : 22:18:41
|
| Does sql agent service account have permission to access remote server? Is job owner sysadmin? |
 |
|
|
|
|
|
DTS SFTP works, the job fails