Hi,
I created a vendor FTP profile in WinSCP GUI named Vendorftp. I have no issue running a batch file to open the Vendorftp profile with my account. However, SQL agent use using userb credential not my account. It is unable to locate Vendorftp profile. It seems like userb will need to create the same vendorftp profile with his credential. How can I export vendorftp profile for userb? What is the proper procedure to let userb to use my vendorftp?
. 2017-11-17 18:16:09.608 --------------------------------------------------------------------------
. 2017-11-17 18:16:09.608 WinSCP Version 5.9.6 (Build 7601) (OS 6.1.7601 Service Pack 1 - Windows Server 2008 R2 Enterprise)
. 2017-11-17 18:16:09.608 Configuration: HKCU\Software\Martin Prikryl\WinSCP 2\
. 2017-11-17 18:16:09.608 Log level: Normal
. 2017-11-17 18:16:09.608 Local account: Mydomain\userb
. 2017-11-17 18:16:09.608 Working directory: D:\Vender
. 2017-11-17 18:16:09.608 Process ID: 22260
. 2017-11-17 18:16:09.609 Command-line: "C:\Program Files (x86)\WinSCP\WinSCP.exe" /console=596 /consoleinstance=_16016_966 "/script=D:\Vender\GetFiles.txt" "/log=D:\Vendor\Logs\WinSCP_log.txt"
. 2017-11-17 18:16:09.609 Time zone: Current: GMT-8, Standard: GMT-8 (Pacific Standard Time), DST: GMT-7 (Pacific Daylight Time), DST Start: 3/12/2017, DST End: 11/5/2017
. 2017-11-17 18:16:09.609 Login time: Friday, November 17, 2017 6:16:09 PM
. 2017-11-17 18:16:09.609 --------------------------------------------------------------------------
. 2017-11-17 18:16:09.609 Script: Retrospectively logging previous script records:
> 2017-11-17 18:16:09.609 Script: open ftp://VENDERFTP
. 2017-11-17 18:16:09.609 --------------------------------------------------------------------------
. 2017-11-17 18:16:09.609 Session name: VENDERFTP (Ad-Hoc site)
. 2017-11-17 18:16:09.609 Host name: VENDERFTP (Port: 21)
. 2017-11-17 18:16:09.609 User name: (Password: No, Key file: No, Passphrase: No)
. 2017-11-17 18:16:09.609 Transfer Protocol: FTP
. 2017-11-17 18:16:09.609 Ping type: Dummy, Ping interval: 30 sec; Timeout: 15 sec
. 2017-11-17 18:16:09.609 Disable Nagle: No
. 2017-11-17 18:16:09.609 Proxy: None
. 2017-11-17 18:16:09.609 Send buffer: 262144
. 2017-11-17 18:16:09.609 UTF: Auto
. 2017-11-17 18:16:09.609 FTPS: None [Client certificate: No]
. 2017-11-17 18:16:09.609 FTP: Passive: Yes [Force IP: Auto]; MLSD: Auto [List all: Auto]; HOST: Auto
. 2017-11-17 18:16:09.609 Local directory: default, Remote directory: home, Update: Yes, Cache: Yes
. 2017-11-17 18:16:09.609 Cache directory changes: Yes, Permanent: Yes
. 2017-11-17 18:16:09.609 Recycle bin: Delete to: No, Overwritten to: No, Bin path:
. 2017-11-17 18:16:09.609 Timezone offset: 0h 0m
. 2017-11-17 18:16:09.609 --------------------------------------------------------------------------
. 2017-11-17 18:16:09.610 Username prompt (no username provided)
. 2017-11-17 18:16:19.633 Connecting to VENDERFTP ...
. 2017-11-17 18:16:22.308 Connection failed.