ASP here to MS Access on another server?

I have a ASP running on one web server trying to access an Access database
on another file server. The problem is WebServer doesn't have permissions to
open the db on FileServer. On FileServer I expected to be able to grant read
permission to IUSR_WebServer but that account doesn't exist in FileServer's
list to choose from. What do I need to do?

FileServer is also a domain controller. WebServer is a standalone Win 2000
server. The error I get seems to indicate access denied. If I copy the same
database to WebServer and use server.mappath("db.mdb") to create the connect
string it works fine. For the other location's connect string I skip the
server.mappath and provide a full UNC path.

thanks
LJB

Bob
Wed Oct 15 10:07:15 CDT 2003

ljb wrote:
> I have a ASP running on one web server trying to access an Access
> database on another file server. The problem is WebServer doesn't
> have permissions to open the db on FileServer. On FileServer I
> expected to be able to grant read permission to IUSR_WebServer but
> that account doesn't exist in FileServer's list to choose from. What
> do I need to do?
>
> FileServer is also a domain controller. WebServer is a standalone Win
> 2000 server. The error I get seems to indicate access denied. If I
> copy the same database to WebServer and use server.mappath("db.mdb")
> to create the connect string it works fine. For the other location's
> connect string I skip the server.mappath and provide a full UNC path.
>
http://www.aspfaq.com/show.asp?id=2168
--
HTH,
Bob Barrows - ASP MVP
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

Tom
Wed Oct 15 10:19:56 CDT 2003

"ljb" <.> wrote in message news:Ohlvf1ykDHA.2732@TK2MSFTNGP11.phx.gbl...
> I have a ASP running on one web server trying to access an Access database
> on another file server. The problem is WebServer doesn't have permissions
to
> open the db on FileServer. On FileServer I expected to be able to grant
read
> permission to IUSR_WebServer but that account doesn't exist in
FileServer's
> list to choose from. What do I need to do?
>
> FileServer is also a domain controller. WebServer is a standalone Win 2000
> server. The error I get seems to indicate access denied. If I copy the
same
> database to WebServer and use server.mappath("db.mdb") to create the
connect
> string it works fine. For the other location's connect string I skip the
> server.mappath and provide a full UNC path.

http://www.aspfaq.com/show.asp?id=2168

--
Tom Kaminski IIS MVP
http://www.iistoolshed.com/ - tools, scripts, and utilities for running IIS
http://mvp.support.microsoft.com/
http://www.microsoft.com/windowsserver2003/community/centers/iis/

ljb
Thu Oct 16 09:16:30 CDT 2003

Thanks for pointing me to that document. I haven't yet verified that it
works in my situation but will try soon.