ASP runs as an anonymous user. Do you understand the difference we are
trying to illustrate here?
You have a database on server A. A web server on server A. And a web
server on server B.
You are looking at server A, and saying "this server can connect to the
database file on server A. Therefore its settings must be correct."
Then you are looking at server B, and saying "this server has the same
settings as server A. Therefore it should be able to connect to the
database."
What you seem to be missing here is that ASP doesn't run as the same user
you are logging in as (what happens when a user requests a page after you
log out?). It runs as an anonymous user that is local to the machine
running the web server. In most cases, this is auser called
IUSR_servername. IUSR_servername on server A (let's call him IUSR_ServerA)
*only* has access to the web folders in the web site on server A. The
anonymous user running under the web service on server B (let's call him
IUSR_ServerB) *only* has access to the web folders in the web site on server
B. It can not just go out and read
The domain has no knowledge of IUSR_ServerA or IUSR_ServerB. Server A has
no knowledge of IUSR_ServerB. Server B has no knowledge of IUSR_ServerA.
Whether you have a user named WEBSRV2 or not is irrelevant... that's not who
ASP is executing as!
So, you have to synchronize these accounts in order for one local anonymous
account to be able to read/write to a folder on a different machine. Did
you look at
http://www.aspfaq.com/2168 at all? Are you getting it yet? I'm
not sure how much more verbose I can get about this. The concept here has
been explained several times to various levels of detail but something is
getting lost on translation, between you and us, or between you and whoever
you're relaying this information to.
Or maybe you should make your life a little simpler and consider keeping the
database and the web application on the same machine. Or use a database
platform that is not so ridiculously tied to the file system...
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Rodger" <ro*******@hotmail.com> wrote in message
news:#5**************@TK2MSFTNGP12.phx.gbl...
Set Right meaning we did a compare of WEBSRV2 (which works) and WEBSRV3
both the same and in the same groups. I did read the TID from Novell and we
have this set as they suggested.
Again I thank both you and Aaron for helping me sooooo much!!
I am going to mention your statment about impersonate again and see what
they tell me . . . .
Rodger