Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 198
  • Last Modified:

IIS to Access DB on different server

I have an IIS4 application running on NT4 server. It talks to an access database using ODBC. While the database resides on the web server, it works fine, however, when I move the database to a share on another NT server, I get a Microsoft OLE DB Provider for ODBC Drivers error '80004005'
 
   [Microsoft][ODBC Microsoft Access 97 Driver] The Microsoft Jet database
   engine cannot open the file '(unknown)'. It is already opened
   exclusively by another user, or you need permission to view its data.

I am not using NT challenge/response, and the anonymous IUSR_computername exists on both servers with the same password. Using server manager on the second server, I can see that IIS is attempting to connect with no username, and so the connection is being refused. How can I force IIS to use the anonymous IUSR_machine name to connect to the second server?
TIA for any help.
0
acsmith
Asked:
acsmith
1 Solution
 
sudenCommented:
You will have to use Access database locally.

Go to the following link.


http://support.microsoft.com/support/kb/articles/Q180/8/15.asp

or goto Article ID: Q180815 in MS Knowledge Base

suden

0
 
acsmithAuthor Commented:
Thanks. Holding the database locally is not really an option. I followed the other two suggested solutions in the KB article, and neither worked :(
Guess i'll have to find another way.
Have some points for pointing me in the right direction though ;)
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now