First of thanks to Faisal and the other contributors for putting these articles up on the web it really helps.
I am using this technique to only load the file up to my sql 2000 database on an Intranet site.
My test web server / dev p.c. is a Windows XP Professional box with SP2. The SQL DB is hosted on a remote Database server.
I have windows integrated authentication checked on the directory security of the web site and I am using a fixed SQL server account to connect to the database via my connection object. This account has insert rights to the table I am uploading to.
When I run the page on my web server / dev p.c. the files are uploaded with out a hitch BUT when one of my colleagues tries to upload from another machine they are prompted to log on to the web server when submitting the form.
My colleagues can all access the rest of mysite correctly including areas where I check their logon id against database tables.
Does anyone have any idea why they are being prompted to log in to the webserver when I am only uploading to the database (not writing a file) and they are conecting to the SQL database via a fixed SQL account?
