Database Connection between servers?

[gbaughma]

Hi there!

I have some ASP scripts running on one server, that I would like to have pull data from another server (Either through DSN or a DSN-less connection, I don't care).

I'm using Access on the data server, and IIS on the script server, but I'm having issues with permissions or something, it states that "File open exclusively or you do not have permission to access this file." If I move the file over to the box that is running the scripts, everything is OK.

Can someone point me in the correct direction to set up permissions so the scripts can connect?

Thanks in advance!



Just my 2¢
-Cole's Law: Shredded cabbage

--Greg

http://parallel.tzo.com

 

[Sheco]

The default security for IIS is anonymous access which uses an account IUSR_<ServerName>

This default account is local to the machine running IIS and it cannot access network resources.

You could user the IIS Admin tool to do one of the following:
A. Disable anonymous access for all pages that need to use network resources or ...
B. Keep anonymous access but specify a particular ActiveDirectory account be used instead (A.K.A. a domain account)

 

[gbaughma]

Solution!

Credentials can be fixed by using the:

Set objLogon = Server.CreateObject("LoginAdmin.ImpersonateUser")

That fixed it.



Just my 2¢
-Cole's Law: Shredded cabbage

--Greg

http://parallel.tzo.com