IIS7: cannot access a database from a page with authentication on local webserver

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/


.

Relevant Pages

  • Re: Can I pass ASP Basic Auth Credentials to an APS.NET Forms Authentication site?
    ... assuming I can get the Username and Password. ... > application which uses basic authentication and one asp.net applicaiton ... The user ID and password database is the ... > A (ASP), so we can get username and password in ASP web application first ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • ASP.NET Forms Authentication Best Practices
    ... ASP.NET Forms Authentication Best Practices ... What happens if your user database is compromised? ... Listing One, where you want to use login.aspx to log users in. ... string FirstName ...
    (microsoft.public.dotnet.framework.aspnet)
  • Can connect to sqlexpress via asp.net but not via asp
    ... I can connect to a sqlexpress database using aspx pages ... Both the asp and aspx pages are within ... The sqlexpress database is also on the same server. ... including dsn, dsn-less, windows authentication, sql authentication ...
    (microsoft.public.sqlserver.connect)
  • User authentication over the web (was: Secure Password in database)
    ... Subject: User authentication over the web (was: Secure Password in database) ... a web server is usually authenticated to users by using SSL or TLS ...
    (SecProg)
  • Re: Using SSPI with Custom Authentication
    ... It boils down to moving the security perimeter away from the server. ... first database contains all of the user information; ... perform authentication, and users need to be authenticated before accessing ...
    (microsoft.public.dotnet.security)