I am running a file upload process to upload files to a db. The web server and the SQL server are different machines. I am attempting to use an SQL OPENROWSET to upload an excel file, but I cannot determine how to get the file onto the other machine. Is there a way to set up a shared drive that the web server can save a file to and the SQL server can access? We have a local network set up with Active Directory.

For Example:

WebServer - Shared drive on web server under C:/inetpub/webpage/fileImport

SQLServer - Will log in with sql auth using USERID and PASSWD. Needs to access webserver shared drive.

What user do I share the drive on web server with so that the sql auth user will be able to access it when I run the OPENROWSET?

Any help will be much appreciated.