"Noël Danjou" <noeld@online.nospam> wrote in message
news:u6jZl2q2HHA.5116@TK2MSFTNGP04.phx.gbl...
> Hello Dan,
>
> Thanks for your reply. The Authenticated Users have Read/Write/Modify
> rights on the folder and the database. I tried the following command (not
> sure if it is correct though) :
>
> icacls %windir%\serviceprofiles\networkservice\AppData\Local\Temp /grant
> "Authenticated Users":(CI)(S,WD,AD,X)
> processed file:
> C:\Windows\serviceprofiles\networkservice\AppData\Local\Temp
> Successfully processed 1 files; Failed processing 0 files
>
> But that did not help. Could you please provide more details about what I
> should exactly do. Thank you.
>
> --
> Noël
> http://noeld.com/
>
>
> "Daniel Crichton" <msnews@worldofspack.com> wrote in message
> news:edMwiCp2HHA.2752@TK2MSFTNGP06.phx.gbl...
>> Noël wrote on Thu, 9 Aug 2007 12:19:16 +0200:
>>
>>> Vista Ultimate / IIS7
>>> MS Access 2000 database
>>
>>> Hello,
>>
>>> I have an .ASP page that requires authentication. I enabled Windows
>>> Authentication in IIS Manager > Authentication.
>>
>>> For the database, I successfully completed the solutions and workaround
>>> in KB article at http://support.microsoft.com/kb/926939/. I also gave
>>> IUSR
>>> > Modify rights to the containing folder and database files.
>>
>>> The ASP page begins as follow:
>>
>>> <% @Language=JScript %>
>>> <%
>>> var bAccessDenied = (Request.ServerVariables("LOGON_USER") == "");
>>
>>> if (bAccessDenied)
>>> {
>>> Response.Status = "401 access denied";
>>> }
>>> else {
>>> var oConn = Server.CreateObject("ADODB.Connection");
>>> var strDBPath = Server.MapPath("/db/data.mdb");
>>> var strOpen = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +
>>> strDBPath;
>>
>>> oConn.Open(strOpen); // <<<< JET error here when authenticated }
>>> %>
>>
>>> When I open the page on a remote server (running IIS6) I can
>>> successfully access the page but when I try it on my local webserver,
>>> I get:
>>
>>> Microsoft JET Database Engine error '80004005'
>>> Unspecified error
>>
>>> Without authentication, the page works correctly remotely and locally.
>>> Could you please tell me how to fix this issue? Thank you.
>>
>>> --
>>> Noël http://noeld.com/
>>
>>
>>
>> As it works without authentication the permissions for the IUSR account
>> are correct. However, with authentication the credentials of the authed
>> user will be used instead - you need to check those to ensure it has the
>> same permissions as you've given the IUSR account.
>>
>> Dan
>>