ASP here to MS Access on another server?

[ljb]

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 Barrows]

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.
>

[url]http://www.aspfaq.com/show.asp?id=2168[/url]
--
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 Kaminski [MVP]]

"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.

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

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

[ljb]

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