Problem in accessing FTP Site over DTS | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Problem in accessing FTP Site over DTS

Hi Friends!
I am facing a real problem on accessing ftp site over DTS. I have created FTP site in IIS with following details:
Allow Anonymous Connection : checkbox checked
Username: METALINK/chandrajits —> First one is domain and second one is windows user name. This is a NT user in which I am working. My os is Win XP professional, IIS is installed in my machine. My system is connected with windows 2000 server where NT users are defined. Password: ****** —-> Given password is the same password for above NT User. Default FTP Site:
IP Address: 192.168.1.4
TCP Port : 21 Enable Logging: Checked
Username and password are the same as given above. allow anonymous connections: Checked
allow only anonymous connections: Checked
allow IIS to contril password: Unchecked Name of the virtual Directory: chandrajits
Actual folder path: F:FtpFiles when I am accessing ftp sith in browser with following URL:
ftp://192.168.1.4/chandrajits
or
ftp://localhost/chandrajits its working and shoiwing the files But I have created a DTS package with File Tranfer protocal Task, where
source URL:ftp://192.168.1.4/chandrajits
(ORftp://localhost/chandrajits)
Username: METALINK/chandrajits
(OR chandrajits) password: ********** —–> same password as I used for ‘chandrajits’ during windows login. its showing one error given below: Unable to Connect to Internet! Please Check the Source Site Information, Your username and password. Please help!!! My all works are stopped because of this.
Regards,
Chandrajit Samanta, MBM(Systems), B.E.(Electrical), Sr. Programmer, Metrica Systems, Bangalore, India, +919986044300, [email protected]
THis is something access to the internet from SQL server, ensure the SQL services has relevant privileges to access FTP on the server. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
]]>