 |
|
|
|
Next: Shockwave Flash from Localhost
|
| Author |
Message |
External
Since: Apr 29, 2005
Posts: 1
|
(Msg. 1) Posted: Fri Apr 29, 2005 1:46 pm
Post subject: Microsoft JET Database Engine error '80004005'
Archived from groups: microsoft>public>inetserver>iis (more info?)
|
|
|
I have a MS Access database(db1.mdb) which is located at a windows 2003
server box (server_03.ses), I have shared the folder with everyone full
access, and NTFS file permite to everyone full access. And domain users
global group is in local users group.
There are two IIS servers, one is windows 2000 (serever_01.ses) and the
orther is windows 2003 (server_02.ses). Both are setting to use integrated
authentication and not allow annonymous access. With an asp page like this
DIM strPath
DIM strConnect
strPath = "\\server_03\db\db1.mdb"
StrConnect = "Provider=Microsoft.Jet.OLEDB.4.0;"
strConnect = strConnect & " Data Source=" & strPath & "; "
Set cnnt = Server.CreateObject("Adodb.connection")
cnn.open strConnect
I always get error message:
Microsoft JET Database Engine error '80004005'
The Microsoft Jet database engine cannot open the file
'\\server_03\db\db1.mdb'. It is already opened exclusively by another user,
or you need permission to view its data.
What I have done is listed following:
1. set system variables TEMP and TMP to c:\TEMP, and give everyone full
access permite. Probelm still there.
2.copy this database to IIS server local drive, it works. But I still want
to use it through network.
3.enabled annonymous access, put my account as default assess, it works. But
I don't want annonymouse access. That just means my account doesn't have
problem.
Any suggestion?
Thanks |
|
| Back to top |
|
 | |
External
Since: Jul 11, 2003
Posts: 65
|
(Msg. 2) Posted: Fri Apr 29, 2005 3:22 pm
Post subject: Re: Microsoft JET Database Engine error '80004005' [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
John Xie wrote:
> I have a MS Access database(db1.mdb) which is located at a windows 2003
> server box (server_03.ses), I have shared the folder with everyone full
> access, and NTFS file permite to everyone full access. And domain users
> global group is in local users group.
>
> There are two IIS servers, one is windows 2000 (serever_01.ses) and the
> orther is windows 2003 (server_02.ses). Both are setting to use integrated
> authentication and not allow annonymous access. With an asp page like this
<snip>
> Any suggestion?
Either make everyone access the database through a web interface, or get a
better database. Not even Microsoft recommends using Access on a web server or
for more than 5-10 simultaneous users.
--
Phil Frisbie, Jr.
Hawk Software
<a style='text-decoration: underline;' href="http://www.hawksoft.com" target="_blank">http://www.hawksoft.com</a><!-- ~MESSAGE_AFTER~ --> |
|
| Back to top |
|
| |
External
Since: Aug 26, 2003
Posts: 392
|
(Msg. 3) Posted: Fri Apr 29, 2005 6:55 pm
Post subject: RE: Microsoft JET Database Engine error '80004005' [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Take a look at the following article:
http://support.microsoft.com/default.aspx?scid=KB;EN-US;306269
This explains many causes of this error.
Hope this helps!
Thank you,
Jackie Jaynes, MCSE, MCSA
IIS Support Engineer
980-776-8723
JackieJa.RemoveThis@microsoft.com
Wed-Sat 9am-8pm EST
Manager: Adam Schultz
Email: adamsc.RemoveThis@microsoft.com <mailto:adamsc@microsoft.com>
Phone: 980.776.9642
Delighting our customers is my top priority. We welcome your comments and
suggestions about the support we provide to you. Please e-mail my manager,
Adam Schultz at <mailto:adamsc@microsoft.com>. Thank you for using
Microsoft products.
Are you secure? For information about the Microsoft Strategic Technology
Protection Program and to order your FREE Security Tool Kit, please visit
<http://www.microsoft.com/security>. >> Stay informed about: Microsoft JET Database Engine error '80004005' |
|
| Back to top |
|
| |
External
Since: Apr 29, 2005
Posts: 3
|
(Msg. 4) Posted: Fri Apr 29, 2005 6:55 pm
Post subject: RE: Microsoft JET Database Engine error '80004005' [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Jacqueline,
Thank you.
I already went through this article. As I said, I used both "Basic
authentication" and "Integrated windows authenticaiton", and my account have
full access to the file. Also, I already tried to copy the file to local
drive, it works. But I want to know how to make it work through network.
John
"Jacqueline Jaynes [MSFT]" wrote:
> Take a look at the following article:
<font color=purple> > <a style='text-decoration: underline;' href="http://support.microsoft.com/default.aspx?scid=KB;EN-US;306269</font" target="_blank">http://support.microsoft.com/default.aspx?scid=KB;EN-US;306269</font</a>>
>
> This explains many causes of this error.
>
> Hope this helps!
>
> Thank you,
>
> Jackie Jaynes, MCSE, MCSA
> IIS Support Engineer
> 980-776-8723
> JackieJa.DeleteThis@microsoft.com
> Wed-Sat 9am-8pm EST
>
> Manager: Adam Schultz
> Email: adamsc.DeleteThis@microsoft.com <mailto:adamsc@microsoft.com>
> Phone: 980.776.9642
>
> Delighting our customers is my top priority. We welcome your comments and
> suggestions about the support we provide to you. Please e-mail my manager,
> Adam Schultz at <mailto:adamsc@microsoft.com>. Thank you for using
> Microsoft products.
>
> Are you secure? For information about the Microsoft Strategic Technology
> Protection Program and to order your FREE Security Tool Kit, please visit
> <http://www.microsoft.com/security>.
>
>
>
><!-- ~MESSAGE_AFTER~ --> >> Stay informed about: Microsoft JET Database Engine error '80004005' |
|
| Back to top |
|
| |
External
Since: Apr 03, 2004
Posts: 367
|
(Msg. 5) Posted: Sat Apr 30, 2005 8:43 am
Post subject: Re: Microsoft JET Database Engine error '80004005' [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
"John Xie" <JohnXie DeleteThis @discussions.microsoft.com> wrote in message
news:8FB37EB5-DD24-45C5-A1D4-D4FADC1402A3@microsoft.com...
> Jacqueline,
>
> Thank you.
> I already went through this article. As I said, I used both "Basic
> authentication" and "Integrated windows authenticaiton", and my account
> have
> full access to the file. Also, I already tried to copy the file to local
> drive, it works. But I want to know how to make it work through network.
Install file monitor from <a style='text-decoration: underline;' href="http://www.sysinternals.com" target="_blank">www.sysinternals.com</a> and see which access is
denied.
I guess, that if you use a remote path, and if you use integrated
authentication (bad because you won't use connection pooling then!) you
need to give them 'logon as a batch' rights and 'access this computer from
the network' (set it on the domain controler using policy editor).
Second, I see you invest a non ignorable amount (3 servers) and you use
Access. You did not ask for this, but this is imho money thrown away. Access
is never built to serve like this. Consider MSDE which is free, limited of
course, but anyway 100x better than access.
--
compatible web farm Session replacement for Asp and Asp.Net
<a style='text-decoration: underline;' href="http://www.nieropwebconsult.nl/asp_session_manager.htm" target="_blank">http://www.nieropwebconsult.nl/asp_session_manager.htm</a>
> John
>
> "Jacqueline Jaynes [MSFT]" wrote:
>
>> Take a look at the following article:
>><!-- ~MESSAGE_AFTER~ --> >> Stay informed about: Microsoft JET Database Engine error '80004005' |
|
| Back to top |
|
| |
External
Since: Jun 10, 2004
Posts: 1807
|
(Msg. 6) Posted: Sat Apr 30, 2005 6:55 pm
Post subject: Re: Microsoft JET Database Engine error '80004005' [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
See:
Why do I get database-related 80004005 errors?
<a style='text-decoration: underline;' href="http://www.aspfaq.com/show.asp?id=2009" target="_blank">http://www.aspfaq.com/show.asp?id=2009</a>
Jeff
On Fri, 29 Apr 2005 13:46:04 -0700, "John Xie" <John
Xie RemoveThis @discussions.microsoft.com> wrote:
>I have a MS Access database(db1.mdb) which is located at a windows 2003
>server box (server_03.ses), I have shared the folder with everyone full
>access, and NTFS file permite to everyone full access. And domain users
>global group is in local users group.
>
>There are two IIS servers, one is windows 2000 (serever_01.ses) and the
>orther is windows 2003 (server_02.ses). Both are setting to use integrated
>authentication and not allow annonymous access. With an asp page like this
>
> DIM strPath
> DIM strConnect
> strPath = "\\server_03\db\db1.mdb"
> StrConnect = "Provider=Microsoft.Jet.OLEDB.4.0;"
> strConnect = strConnect & " Data Source=" & strPath & "; "
> Set cnnt = Server.CreateObject("Adodb.connection")
> cnn.open strConnect
>
>I always get error message:
>
>Microsoft JET Database Engine error '80004005'
>
>The Microsoft Jet database engine cannot open the file
>'\\server_03\db\db1.mdb'. It is already opened exclusively by another user,
>or you need permission to view its data.
>
>What I have done is listed following:
>
>1. set system variables TEMP and TMP to c:\TEMP, and give everyone full
>access permite. Probelm still there.
>2.copy this database to IIS server local drive, it works. But I still want
>to use it through network.
>3.enabled annonymous access, put my account as default assess, it works. But
>I don't want annonymouse access. That just means my account doesn't have
>problem.
>
>Any suggestion?
>
>Thanks
><!-- ~MESSAGE_AFTER~ --> >> Stay informed about: Microsoft JET Database Engine error '80004005' |
|
| Back to top |
|
| |
External
Since: Aug 23, 2003
Posts: 3041
|
(Msg. 7) Posted: Sun May 01, 2005 8:55 pm
Post subject: Re: Microsoft JET Database Engine error '80004005' [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
You are running into a double-hop authentication problem. The IIS server
does not have the user's username and password, it only has a token that
does not have privileges to logon to a remote server as the user. Hence the
error you are getting.
If you are using Integrated Windows Authentication, you need to ensure that
Kerberos authentication is being used, and delegation is configured.
Otherwise, use Basic (insecure) authentication instead:
http://www.microsoft.com/technet/prodtechnol/windowsserver2003/technol...es/secu
Cheers
Ken
--
Blog: www.adopenstatic.com/cs/blogs/ken/
Web: www.adopenstatic.com
"John Xie" <John Xie.DeleteThis@discussions.microsoft.com> wrote in message
news:DDBE4522-1596-4CC0-B43E-B526594467AC@microsoft.com...
:I have a MS Access database(db1.mdb) which is located at a windows 2003
: server box (server_03.ses), I have shared the folder with everyone full
: access, and NTFS file permite to everyone full access. And domain users
: global group is in local users group.
:
: There are two IIS servers, one is windows 2000 (serever_01.ses) and the
: orther is windows 2003 (server_02.ses). Both are setting to use integrated
: authentication and not allow annonymous access. With an asp page like this
:
: DIM strPath
: DIM strConnect
: strPath = "\\server_03\db\db1.mdb"
: StrConnect = "Provider=Microsoft.Jet.OLEDB.4.0;"
: strConnect = strConnect & " Data Source=" & strPath & "; "
: Set cnnt = Server.CreateObject("Adodb.connection")
: cnn.open strConnect
:
: I always get error message:
:
: Microsoft JET Database Engine error '80004005'
:
: The Microsoft Jet database engine cannot open the file
: '\\server_03\db\db1.mdb'. It is already opened exclusively by another
user,
: or you need permission to view its data.
:
: What I have done is listed following:
:
: 1. set system variables TEMP and TMP to c:\TEMP, and give everyone full
: access permite. Probelm still there.
: 2.copy this database to IIS server local drive, it works. But I still want
: to use it through network.
: 3.enabled annonymous access, put my account as default assess, it works.
But
: I don't want annonymouse access. That just means my account doesn't have
: problem.
:
: Any suggestion?
:
: Thanks
:
: >> Stay informed about: Microsoft JET Database Engine error '80004005' |
|
| Back to top |
|
| |
External
Since: Apr 29, 2005
Posts: 3
|
(Msg. 8) Posted: Mon May 02, 2005 6:28 am
Post subject: Re: Microsoft JET Database Engine error '80004005' [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
First, The account I used to test is domain administrator account, which
should not have any permition problem.
Second, thank you, I don't like access neither. This is an old aplication, I
have to maintain it. Two web servers here just want to say that it's not the
problem of different windows versions.
Thanks.
"Egbert Nierop (MVP for IIS)" wrote:
> "John Xie" <JohnXie.TakeThisOut@discussions.microsoft.com> wrote in message
> news:8FB37EB5-DD24-45C5-A1D4-D4FADC1402A3@microsoft.com...
> > Jacqueline,
> >
> > Thank you.
> > I already went through this article. As I said, I used both "Basic
> > authentication" and "Integrated windows authenticaiton", and my account
> > have
> > full access to the file. Also, I already tried to copy the file to local
> > drive, it works. But I want to know how to make it work through network.
>
> Install file monitor from <a style='text-decoration: underline;' href="http://www.sysinternals.com" target="_blank">www.sysinternals.com</a> and see which access is
> denied.
>
> I guess, that if you use a remote path, and if you use integrated
> authentication (bad because you won't use connection pooling then!) you
> need to give them 'logon as a batch' rights and 'access this computer from
> the network' (set it on the domain controler using policy editor).
>
> Second, I see you invest a non ignorable amount (3 servers) and you use
> Access. You did not ask for this, but this is imho money thrown away. Access
> is never built to serve like this. Consider MSDE which is free, limited of
> course, but anyway 100x better than access.
>
> --
> compatible web farm Session replacement for Asp and Asp.Net
<font color=purple> > <a style='text-decoration: underline;' href="http://www.nieropwebconsult.nl/asp_session_manager.htm</font" target="_blank">http://www.nieropwebconsult.nl/asp_session_manager.htm</font</a>>
>
>
> > John
> >
> > "Jacqueline Jaynes [MSFT]" wrote:
> >
> >> Take a look at the following article:
> >>
>
><!-- ~MESSAGE_AFTER~ --> >> Stay informed about: Microsoft JET Database Engine error '80004005' |
|
| Back to top |
|
| |
External
Since: Apr 29, 2005
Posts: 3
|
(Msg. 9) Posted: Mon May 02, 2005 6:36 am
Post subject: Re: Microsoft JET Database Engine error '80004005' [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Ken,
I tried to use basic authentication, it works. I haven't setup Kerberos
authenticaiton, I don't have CA server in the domain. Any information on how
to setup kerberos authenticaiton?
Thanks.
John
"Ken Schaefer" wrote:
> You are running into a double-hop authentication problem. The IIS server
> does not have the user's username and password, it only has a token that
> does not have privileges to logon to a remote server as the user. Hence the
> error you are getting.
>
> If you are using Integrated Windows Authentication, you need to ensure that
> Kerberos authentication is being used, and delegation is configured.
> Otherwise, use Basic (insecure) authentication instead:
<font color=purple> > <a style='text-decoration: underline;' href="http://www.microsoft.com/technet/prodtechnol/windowsserver2003/technologies/security/tkerbdel.mspx</font" target="_blank">http://www.microsoft.com/technet/prodtechnol/windowsserver2003/technol...es/secu</a>>
>
> Cheers
> Ken
>
> --
<font color=purple> > Blog: <a style='text-decoration: underline;' href="http://www.adopenstatic.com/cs/blogs/ken/</font" target="_blank">www.adopenstatic.com/cs/blogs/ken/</font</a>>
<font color=purple> > Web: <a style='text-decoration: underline;' href="http://www.adopenstatic.com</font" target="_blank">www.adopenstatic.com</font</a>>
>
>
> "John Xie" <John Xie.TakeThisOut@discussions.microsoft.com> wrote in message
> news:DDBE4522-1596-4CC0-B43E-B526594467AC@microsoft.com...
> :I have a MS Access database(db1.mdb) which is located at a windows 2003
> : server box (server_03.ses), I have shared the folder with everyone full
> : access, and NTFS file permite to everyone full access. And domain users
> : global group is in local users group.
> :
> : There are two IIS servers, one is windows 2000 (serever_01.ses) and the
> : orther is windows 2003 (server_02.ses). Both are setting to use integrated
> : authentication and not allow annonymous access. With an asp page like this
> :
> : DIM strPath
> : DIM strConnect
> : strPath = "\\server_03\db\db1.mdb"
> : StrConnect = "Provider=Microsoft.Jet.OLEDB.4.0;"
> : strConnect = strConnect & " Data Source=" & strPath & "; "
> : Set cnnt = Server.CreateObject("Adodb.connection")
> : cnn.open strConnect
> :
> : I always get error message:
> :
> : Microsoft JET Database Engine error '80004005'
> :
> : The Microsoft Jet database engine cannot open the file
> : '\\server_03\db\db1.mdb'. It is already opened exclusively by another
> user,
> : or you need permission to view its data.
> :
> : What I have done is listed following:
> :
> : 1. set system variables TEMP and TMP to c:\TEMP, and give everyone full
> : access permite. Probelm still there.
> : 2.copy this database to IIS server local drive, it works. But I still want
> : to use it through network.
> : 3.enabled annonymous access, put my account as default assess, it works.
> But
> : I don't want annonymouse access. That just means my account doesn't have
> : problem.
> :
> : Any suggestion?
> :
> : Thanks
> :
> :
>
>
><!-- ~MESSAGE_AFTER~ --> >> Stay informed about: Microsoft JET Database Engine error '80004005' |
|
| Back to top |
|
| |
External
Since: Aug 23, 2003
Posts: 3041
|
(Msg. 10) Posted: Mon May 02, 2005 7:55 pm
Post subject: Re: Microsoft JET Database Engine error '80004005' [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
You don't need a CA to setup Kerberos authentication. Kerberos is the native
auth mode for Windows 2000 and Windows 2003 domains.
Did you read the article I posted?
Cheers
Ken
--
Blog: www.adopenstatic.com/cs/blogs/ken/
Web: www.adopenstatic.com
"John Xie" <JohnXie DeleteThis @discussions.microsoft.com> wrote in message
news:F932AEFF-E971-4A30-86C7-0CFB85EDE6A1@microsoft.com...
: Ken,
:
: I tried to use basic authentication, it works. I haven't setup Kerberos
: authenticaiton, I don't have CA server in the domain. Any information on
how
: to setup kerberos authenticaiton?
:
: Thanks.
:
: John
:
: "Ken Schaefer" wrote:
:
: > You are running into a double-hop authentication problem. The IIS server
: > does not have the user's username and password, it only has a token that
: > does not have privileges to logon to a remote server as the user. Hence
the
: > error you are getting.
: >
: > If you are using Integrated Windows Authentication, you need to ensure
that
: > Kerberos authentication is being used, and delegation is configured.
: > Otherwise, use Basic (insecure) authentication instead:
: >
http://www.microsoft.com/technet/prodtechnol/windowsserver2003/technol...es/secu
: >
: > Cheers
: > Ken
: >
: > --
: > Blog: www.adopenstatic.com/cs/blogs/ken/
: > Web: www.adopenstatic.com
: >
: >
: > "John Xie" <John Xie DeleteThis @discussions.microsoft.com> wrote in message
: > news:DDBE4522-1596-4CC0-B43E-B526594467AC@microsoft.com...
: > :I have a MS Access database(db1.mdb) which is located at a windows 2003
: > : server box (server_03.ses), I have shared the folder with everyone
full
: > : access, and NTFS file permite to everyone full access. And domain
users
: > : global group is in local users group.
: > :
: > : There are two IIS servers, one is windows 2000 (serever_01.ses) and
the
: > : orther is windows 2003 (server_02.ses). Both are setting to use
integrated
: > : authentication and not allow annonymous access. With an asp page like
this
: > :
: > : DIM strPath
: > : DIM strConnect
: > : strPath = "\\server_03\db\db1.mdb"
: > : StrConnect = "Provider=Microsoft.Jet.OLEDB.4.0;"
: > : strConnect = strConnect & " Data Source=" & strPath & "; "
: > : Set cnnt = Server.CreateObject("Adodb.connection")
: > : cnn.open strConnect
: > :
: > : I always get error message:
: > :
: > : Microsoft JET Database Engine error '80004005'
: > :
: > : The Microsoft Jet database engine cannot open the file
: > : '\\server_03\db\db1.mdb'. It is already opened exclusively by another
: > user,
: > : or you need permission to view its data.
: > :
: > : What I have done is listed following:
: > :
: > : 1. set system variables TEMP and TMP to c:\TEMP, and give everyone
full
: > : access permite. Probelm still there.
: > : 2.copy this database to IIS server local drive, it works. But I still
want
: > : to use it through network.
: > : 3.enabled annonymous access, put my account as default assess, it
works.
: > But
: > : I don't want annonymouse access. That just means my account doesn't
have
: > : problem.
: > :
: > : Any suggestion?
: > :
: > : Thanks
: > :
: > :
: >
: >
: > >> Stay informed about: Microsoft JET Database Engine error '80004005' |
|
| Back to top |
|
| |
|
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
|
|
|
FAQ
Search
Profile
Private Messages
Log in
