SQL Server2000 SP3


I have been trying to create a DTS that uses an FTP task

The DTS executes fine from the DTS designer window

However, when I try and run the DTS from ASP....

On the development server where the database is on the
same system as the web-server all works fine my file gets transfered
to the correct dir

However, when I try to call the DTS from ASP on our production web-server
with the dev machine as the database server the

DTS says successfull but the file is not being transferred.



Does anyone know if there is something speciall I have to do when
calling the DTS when the Web-server and database system are on seperate
systems...


I am leanning towards a security or access issue between the DTS and
the target dir where I want to transfer the file...

on the target dir I set permisson to EVERYONE with full control




What I am trying to accomplish is

1. user goes to web-site browses for file
2. file gets transfered to web-server
3. use DTS to FTP file to database server
4. use file in DTS to bulk insert into database table


Thanks for the help
nevlis

It will be, as you have correctly identified, an issue with security. I am
inclined to start here.

http://support.microsoft.com/?kbid=252987

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"nevlis" <silven (AT) removesilven (DOT) canada.com> wrote

Whould you have any idea of which users should have what permissions
when trying to run DTS with FTP from ASP


Thanks for the help

nevlis

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote in news:OvhE0sA#EHA.1264
@TK2MSFTNGP12.phx.gbl:

If it is an anonymous site it will be IUSER_MACHINE_NAME. If not then it
should be the Windows user

Here is a code check from Darren

Dim WshShell, WshNetwork

Set WshShell = CreateObject("WScript.Shell")
Set WshNetwork = CreateObject("WScript.Network")


sLogString = "ComputerName: " & WshNetwork.ComputerName & vbCrLf
& _


"UserDomain: " & WshNetwork.UserDomain & vbCrLf & _
"UserName: " & WshNetwork.UserName & vbCrLf

WshShell.LogEvent 0, sLogString


Set WshShell = Nothing
Set WshNetwork = Nothing




--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"nevlis" <silven (AT) removesilven (DOT) canada.com> wrote

Ok with your script I was able to determine that the user
when running the script in ASP is IUSR_WEBWHATEVER


However this user does not exists on the database server.

I am assuming that the non existance of the user is why I cannot FTP the
user does not have permissions on the target dir?

If this is the case how does one get around the problem...


Thanks for the help


nevlis

Can you create a user with the exact same name and password?

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"nevlis" <silven (AT) removesilven (DOT) canada.com> wrote

Apparently I cannot ... I asked my web/database administrator and
he said that the reason is that it sever creates random or dynamic
passwords each time for the ISUR_...

apparently if he changes it this may affect other web-sites


thanks
nevlis