Authentication Failed - HELP

[Teggaman]

Hi,

I'm trying to set up my home pc with 2000 pro IIS 5 installed. After
writing a simple asp page to open a database and pull back the records
of a table to test, I am getting an error :-

c:\inetpub\wwwroot\adotest\backup\myhols.mdb
Provider error '80040e4d'

Authentication failed.

I have checked all the usual errors:-
set up iusr guest account for full rights
set up anomonous authentication
even followed tech nets advise to give iusr 'act as part as os' within
user rights assignment

Microsoft script debugger says it gets the Authentication error on the
following line:-

conn.Open localpath

within

localpth = Server.MapPath("/adotest/backup/myhols.mdb")
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open localpath

Thanks for any help anybody can give me.

Greg C

[Ray at]

Is the .mdb password protected?

Ray at work

"Teggaman" <gr**********@yahoo.co.uk> wrote in message
news:46**************************@posting.google.c om...

Hi,

I'm trying to set up my home pc with 2000 pro IIS 5 installed. After
writing a simple asp page to open a database and pull back the records
of a table to test, I am getting an error :-

c:\inetpub\wwwroot\adotest\backup\myhols.mdb
Provider error '80040e4d'

Authentication failed.

I have checked all the usual errors:-
set up iusr guest account for full rights
set up anomonous authentication
even followed tech nets advise to give iusr 'act as part as os' within
user rights assignment

Microsoft script debugger says it gets the Authentication error on the
following line:-

conn.Open localpath

within

localpth = Server.MapPath("/adotest/backup/myhols.mdb")
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open localpath

Thanks for any help anybody can give me.

Greg C

[Teggaman]

Hi Ray,

The Access DB is not protected and I have tried to connect to the
microsoft database shipped with Access to no avail. The problem seems
to lie local with my machine or with IIS 5

Thanks

Greg


Ray at <%=sLocation%>" <myFirstNameATlane34dotKOMM> wrote in message news:<eV**************@tk2msftngp13.phx.gbl>...

Is the .mdb password protected?

Ray at work

"Teggaman" <gr**********@yahoo.co.uk> wrote in message
news:46**************************@posting.google.c om...

Hi,

I'm trying to set up my home pc with 2000 pro IIS 5 installed. After
writing a simple asp page to open a database and pull back the records
of a table to test, I am getting an error :-

c:\inetpub\wwwroot\adotest\backup\myhols.mdb
Provider error '80040e4d'

Authentication failed.

I have checked all the usual errors:-
set up iusr guest account for full rights
set up anomonous authentication
even followed tech nets advise to give iusr 'act as part as os' within
user rights assignment

Microsoft script debugger says it gets the Authentication error on the
following line:-

conn.Open localpath

within

localpth = Server.MapPath("/adotest/backup/myhols.mdb")
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open localpath

Thanks for any help anybody can give me.

Greg C