login about faq

We are not able to run the sftp.bat batch file in SQL Server Job it gives message "unable to connect to FTP server", but when we run batch file independently it is running and connecting to FTP server. do we have to do any setting at SQL SERVER so that we can connect to SSH tectia server and download the file. We are stuck with this step unable to proceed further kindly help

asked Jan 02 '12 at 19:56

Parekada's gravatar image

Parekada
1222


The sql server is likely running the job as the SYSTEM user. Can you double check what the SQL Server Service user is running as? I'm assuming the batch file is running with some kind of non-user interactive setup. If its running as SYSTEM you would need to either change the user its running as, or set up the keys (host keys and User keys (if your using key auth)) in the "All Users" profile directly.

As you may expect there are some pretty significant security risks setting up a non-interactive auth in the "All Users" profile, and this is not recommended.

link

answered Jan 05 '12 at 05:43

Joe%20-%20Tectia%20Support's gravatar image

Joe - Tectia Support ♦♦
55215

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or __italic__
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×82

Asked: Jan 02 '12 at 19:56

Seen: 4,574 times

Last updated: Jan 05 '12 at 05:43

All user contributed content licensed under the cc-by-sa license.
Powered by OSQA.