Re: ASP.NET & Access database

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Ok, it's working now. If I open my website on my app server, on which the
access database is, it works fine. If I however run the app local with the
access data on the server (like when you are still coding), then my problems
return with a vengeance.

If I use impersonation with usename="NT AUTHORITY\NETWORK SERVICE" it still
runs ok until I try to open the page that requests the access database. The
above username is what is being used when I run it on the server with no
problems.

Any ideas as to which user name to use or is my problem elsewhere?

Regards
MW


"Juan T. Llibre" <nomailreplies@xxxxxxxxxxx> wrote in message
news:uesBwyoaFHA.2444@xxxxxxxxxxxxxxxxxxxxxxx
> MW,
>
> There's two types of permissions needed in order to be
> able to access data in a database in an external server:
>
> 1. database permissions
> 2. file permissions
>
> re:
>> I have setup the connection string to have the username = admin
>
> That corresponds to the database permission and is fine that way.
>
> You also need to allow file permission access to
> the account under which ASP.NET is running.
>
> i.e.,
> your ASP.NET account must have permission to access \\Server1\DataFolder\
>
> Notice that you need read/write permissions assigned for the full folder,
> and not just for the database file.
>
>
>
>
> Juan T. Llibre
> ASP.NET MVP
> http://asp.net.do/foros/
> Foros de ASP.NET en Español
> Ven, y hablemos de ASP.NET...
> ======================
>
> "MW de Jager" <mwdejager@xxxxxxxxxxxxxxxxx> wrote in message
> news:d81778$5rb$1@xxxxxxxxxxxxxxxxxxxxx
>> I'm having endless problems with gaining access to an Access Database
>> that sits on a different server. My ASP.NET app cannot gain control.
>> The errror message I get is:
>>
>> The Microsoft Jet database engine cannot open the file
>> '\\Server1\DataFolder\Countries5.mdb'. It is already opened exclusively
>> by another user, or you need permission to view its data.
>>
>> I have setup the connection string to have the username = admin and the
>> password is blank. At design time I can see the data no problem, yet as
>> soon as the ASP.NET app is running, I get the above error.
>>
>> Any ideas anyone?
>>
>> Regards
>> MW
>>
>
>


.

Relevant Pages

  • RE: copy permissions from one user to another?
    ... THIS STORED PROCEDURE GENERATES COMMANDS ... -- ADD USER TO SERVER ... -- CREATE TABLE TO HOLD LIST OF USERS IN CURRENT DATABASE ... -- SET COMMAND TO FIND USER PERMISSIONS HAS IN CURRENT DATABASE ...
    (microsoft.public.sqlserver.security)
  • Re: Problems with MS Access data source
    ... > Same on both systems or correct for Server 2003? ... The NTFS permissions are the same on both systems, ... Web app does not use ISAPI ... which part in its configuration can be the ...
    (microsoft.public.inetserver.iis.security)
  • Re: Effective Permissions Error with Domain User
    ... I set the database compatibility to 2005. ... server profile trace and found that it was calling the Execute As User. ... This leads me to believe it is some sort of permissions issue. ... Did you get these database from SQL Server 2000 by using a RESTORE command? ...
    (microsoft.public.sqlserver.security)
  • Re: Prolog on a web server
    ... thrilled if you wanted to load it all into server VM:-/ ... rapidly build yourself a desktop app (Delphi? ... As for Prolog, it could surely be the basis of a decent ... grown-up database query language (an open standard dialect ...
    (comp.lang.prolog)
  • Re: Python Database Apps
    ... It's gonna be a desktop app. ... so that I don't need a database server on the client side. ... If you have an offline mode then the most important thing to work out ...
    (comp.lang.python)