Re: Connect to database on other computer

From: Dave F. (dflower_at_gmail.com)
Date: 07/28/05

  • Next message: Perecli Manole: "Re: how to prevent auth ticket expiration" 
    Date: Thu, 28 Jul 2005 09:30:39 -0700

    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

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

  • Next message: Perecli Manole: "Re: how to prevent auth ticket expiration"

    Relevant Pages

    • Re: Connecting to FoxPro from .NET
      ... I understand that this is a permissions issue. ... the passwords for the account. ... FoxPro Driver]File 'table.dbf' does not exist ... You are accessing "table.dbf" at a remote server, ...
      (microsoft.public.dotnet.framework.aspnet)
    • File Permissions with Access 2007 and Vista
      ... I copied a previous Access database to my wife's documents folder and some to ... From my user account I can run all my previous Access databases in my ... There are no permissions internal to the Access ...
      (microsoft.public.access.security)
    • RE: Connect to MS Access DB on different server
      ... The "IS-Users" account is a domain group, ... permissions to the folder where the Access database resides. ...
      (microsoft.public.dotnet.framework.aspnet.security)
    • Re: Unable to mount disk (local and remote) using Windows 2000 task scheduler
      ... Try adding the same local account username and password to the remote server ... with permissions to the resource. ...
      (microsoft.public.win2000.general)
    • Re: Incoming E-Mail - cant create contact in OU
      ... account out of local administrator to attempt to find any denied access. ... I then added full permissions to my user account on both of these keys, ... local admin rights to the server hosting incoming email. ... what permission I need to give the app pool locally to avoid this issue. ...
      (microsoft.public.sharepoint.windowsservices)