Hi Chris,
I had a similar problem accessing data on a remote server. I had to setup a
user account on the remote server and give it full permissions on the folder
that contains the mdb file.
Then I had to create an identical user on the IIS server (same username and
password) and give basic permissions to the ASP.NET application folder. Then
in the IIS manager you need to open the properties of your application, make
sure Anonymous login is checked. Then edit the Account used for anonymous
access to reflect your new username and password. Make sure that the Allow
IIS to control password box is unchecked.Put a check in Basic authentication
and fill in the Default domain and Realm. Be sure the Integrated Windows
authentication box is checked and click OK.
You can review the following article from CodeProject to get an idea of what
else to do. Be sure to click the MSDN link in this article. It gives you
instructions on how to setup user permissions on other folders.
http://www.codeproject.com/aspnet/Sec_Run_ASPNET_WP.asp Hope this helps
[quoted text, click to view] "Paul Clement" <UseAdddressAtEndofMessage@swspectrum.com> wrote in message
news:bv9qc11lc6g183sae6eog3m5pqefqfct6r@4ax.com...
> On Thu, 07 Jul 2005 01:54:11 -0700, Chris Zopers <test123test12@12move.nl>
> wrote:
>
> ¤ Hello,
> ¤
> ¤ I use an MS Access database. I've tried impersonation with a user
> ¤ loginname and password that has full permissions. With that useraccount
> ¤ I can directly open the MS Access database, but when my ASP.NET
> ¤ application impersonates that user, it still won't connect to that same
> ¤ MS Access database.
>
> If you're using Integrated Windows authentication for your web app,
> credentials cannot be delegated
> without implementing Kerberos. However you should be able to use Basic
> authentication assuming that
> you're logging in with a domain account that has the appropriate
> permissions for the resource (which
> appears to be what you've indicated).
>
> You should also be using a UNC path to the database in your connection
> string and not a path mapped
> to a local drive letter.
>
>
> Paul
> ~~~~
> Microsoft MVP (Visual Basic)
