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]

Re: Connections Strings

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" <Charles@Create ItSoftware.net> wrote in message
news:ezB7jmt4EH A.1292@TK2MSFTN GP10.phx.gbl...[color=blue]
> 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
>[/color]

[Paul Clement]

Re: Connections Strings

On Wed, 15 Dec 2004 11:09:53 -0800, "Charles A. Lackman" <Charles@Create ItSoftware.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.aspx?scid=kb;en-us;810572

Paul ~~~ pclement@amerit ech.net
Microsoft MVP (Visual Basic)