Connections Strings

[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

[Isaias Formacio-Serna]

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

"Charles A. Lackman" <Ch*****@CreateItSoftware.net> wrote in message
news:ez**************@TK2MSFTNGP10.phx.gbl...

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

[Paul Clement]

On Wed, 15 Dec 2004 11:09:53 -0800, "Charles A. Lackman" <Ch*****@CreateItSoftware.net> wrote:

¤ 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...b;en-us;810572
Paul ~~~ pc******@ameritech.net
Microsoft MVP (Visual Basic)