SQL Server Performance Forum – Threads Archive
Problem in accessing FTP Site over DTSHi 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://localhost/chandrajits its working and shoiwing the files But I have created a DTS package with File Tranfer protocal Task, where
(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.
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
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.