Re: Permission to access remote database

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Tommy (Websoftwares_at_Hotmail.com)
Date: 02/02/04 

Date: 2 Feb 2004 10:39:43 -0800

Could you provide additional information on the security configuration
of your ASP.NET application on Machine A? For example, are you using
anonymous access? Are you using impersonation?

If you're not using impersonation, an ASP.NET web application runs in
the context of the "ASPNET" user. This user is a local user on
Machine A, so it will not have access to the resource on Machine B
even if Machine B has 'Everyone' access. "Everyone" in Machine B
means every local and every network user. The "ASPNET" user does not
belong to either group.

Try using impersonation, and have the ASP.NET application run under a
network user. For example, add the following tag to the Web.Config.

<identity impersonate="true"
          userName="domain1\user1"
          password="master"/>

The above tag will make your ASP.NET application run under a the
network user "User1" in "Domain1". If this network user has access to
Machine B, then you should not get access denied anymore.

Tommy,

"jn" <anonymous@discussions.microsoft.com> wrote in message news:<A431A042-364F-4588-89AE-B473FBAE656D@microsoft.com>...
> This is more of a network problem, but any help would be appreciated.
> I have my asp.net application on machine A, which tries to get the data from a database located on machine B. Machine B has 'Everyone' access. Right now my application can't access the data on machine B because of access rights. Could someone help me on how to configure my application and machine B to make this work? Thanks.