Connections Strings

  • Thread starter Thread starter Charles A. Lackman
  • Start date Start date
C

Charles A. Lackman

Hello,

I have created a web site that is being run on a Web Server (Computer #1)
and information from the web site is stored in an access (Jet 4.0) database
on another computer (Computer #2). Computer #2 is a domain controller and
has a folder that is shared to hold the database. When the web visitor
click's "Submit" an error occurs and I believe it is because the connection
string cannot access the shared folder on the domain. How should I solve
this problem?

1) Should I add the Web User Account as a member of the domain?

2) Should I (if possible, and if so how) add the domain "UserName" and
"Password" to the connection string so that when the data is being sent it
gains access to the shared folder on the domain?

If I am barking up the wrong tree, please let me know.

Any suggestions will be greatly appreciated.

Thank,

Chuck
 
You have to create an account in the domain, in computer 1 configure in the
IIS > your application's properties > Directory Security > Anonymous access
and authentication > Change gue user for anonymous access for that user;
then in the folder of computer 2 give enough permissions for the same domain
user to access the files.

-IFS
 
¤ Hello,
¤
¤ I have created a web site that is being run on a Web Server (Computer #1)
¤ and information from the web site is stored in an access (Jet 4.0) database
¤ on another computer (Computer #2). Computer #2 is a domain controller and
¤ has a folder that is shared to hold the database. When the web visitor
¤ click's "Submit" an error occurs and I believe it is because the connection
¤ string cannot access the shared folder on the domain. How should I solve
¤ this problem?
¤
¤ 1) Should I add the Web User Account as a member of the domain?
¤
¤ 2) Should I (if possible, and if so how) add the domain "UserName" and
¤ "Password" to the connection string so that when the data is being sent it
¤ gains access to the shared folder on the domain?
¤
¤ If I am barking up the wrong tree, please let me know.
¤
¤ Any suggestions will be greatly appreciated.

Once you start accessing remote resources from the web server you're operating under a delegation
scenario. I don't know what type of authentication your web application is implementing but if you
use Basic (w/o SSL) with impersonation you should be able to transparently pass credentials to the
remote resource.

The alternative is to implement Kerberos delegation:

http://support.microsoft.com/default.aspx?scid=kb;en-us;810572


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
Back
Top