Remote SQL Connectivity Problem with ASP.Net Web Application

[Hammad Rajjoub]

Hello,

I am connecting to a remote sql server using asp.net web application, the error that i get is "Sql Server does not exist or access denied". now when i use the same query string in a windows based application then connection is made successfully.

am i missing some thing in web.config file (i ve set authentication mode to none)

please respond asap, i badly need to fix this problem

thanks in advance

Hammad.Rajjoub.

 

[Ken Schaefer]

If you are running ASP.NET under it's default process identity, then it may
not have access to remote resources. For example, in Windows 2000, ASP.NET
runs under Machine\ASPNET or Machine\IWAM_<machinename> for v1 and v1.1
respectively. These are local accounts and do not have access to remote
resources. You will need to change the process identity to something else.

On Windows 2003, ASP.NET uses the Web App Pool process identity. You will
need to configure that so that it has access to remote resources.

Cheers
Ken

: Hello,
:
: I am connecting to a remote sql server using asp.net web application, the
error that i get is "Sql Server does not exist or access denied". now when i
use the same query string in a windows based application then connection is
made successfully.
:
: am i missing some thing in web.config file (i ve set authentication mode
to none) ?
:
: please respond asap, i badly need to fix this problem .
:
: thanks in advance.
:
: Hammad.Rajjoub.

 

[Hammad Rajjoub]

Hello Ken,

I have actually changed asp.net process identity to Administrator, and
the remote server(having sql server) installed on it has the same
Administrator UserId / Password as on web server.

What else do i need to check ?

Thanks for the response.

regards,
Hammad.Rajjoub.

 

[Ken Schaefer]

Hi,

Are you using Integrated Windows security in your SQL Server connection
string (Integrated Security=SSPI)? If so, then having two local
administrator accounts with the same password is not enough (as far as I
know - someone else who knows more about how the SSPI interface works might
be able to help you more). You will need to use a domain account instead, or
you somehow need to impersonate the remote administrator account (I don't
know how that's possible though).

Cheers
Ken

: Hello Ken,
:
: I have actually changed asp.net process identity to Administrator, and
: the remote server(having sql server) installed on it has the same
: Administrator UserId / Password as on web server.
:
: What else do i need to check ?
:
: Thanks for the response.
:
: regards,
: Hammad.Rajjoub.
:
:
: Don't just participate in USENET...get rewarded for it!