NTFS Permissions between servers & SA FileUp / FSO

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Other Forums

Other Topics

NTFS Permissions between servers & SA FileUp / FSO

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-07-10 : 09:05:09

Maximillian writes "Greetings!

I am sure this is a common question, but I have been unable to find the info yet. This is regarding regular old ASP, not .NET.

2 networked servers, Windows 2000 Server, fully up-to-date. The first is the webserver, where all the ASP action happens. The second server has some vb daemons runnings to process uploaded data and so on. How can I use ASP to upload a file from an anonymous (but with an ASP session in all cases) user to upload a file that would ultimately be saved on the second server's destination directory? I have been using FileUp with and without using the FileSystemObject with the same results in both cases.

Set upl = server.createobject("SoftArtisans.FileUp")
filename= Session("UploadDir") & fname
upl.SaveAs filename

When the "UploadDir" session var is set to a networked drive mapped ("U:\") to another server, I get a permissions error generated by FileUp. So I tried saving a temp dir using the above snippet, and using FSO to move it:

Set fso = CreateObject("Scripting.FileSystemObject")
newfilename="U:\"&"movedFile.txt"
fso.CopyFile(filename),newfilename

I still get

Microsoft VBScript runtime error '800a0046'

Permission denied

Help?"

robvolk
Most Valuable Yak

15732 Posts

Posted - 2002-07-10 : 09:56:25

You'll have to ask some ASP sites about this, SQL Server doesn't come into play here.

Try these:

www.4guysfromrolla.com
www.aspmessageboard.com
www.15seconds.com
www.asp101.com
www.aspalliance.com

AjarnMark
SQL Slashing Gunting Master

3246 Posts

Posted - 2002-07-10 : 14:59:33

The ASP sites Rob mentions are probably your best bet, but here's a WAG... Does you IUSR_MachineName (anonymous web user) from machine one have permissions on machine 2?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources