SQLCONNECTION Login failed for user URGENT

[Silvia Brunet Jones]

Ok I have this big problem again.
I have my IIS Server in one maching and my SQL DB in
another. It needs to stay this way.
I am connection with windows authentication to IIS

<authentication mode="Windows" />
<identity impersonate="true" />


and my connection string looks like this

"Trusted_Connection=Yes;data source=NET_SERV_RS;integrated
security=SSPI;initial
catalog=RDBP1;pooling=true;connection lifetime=180;min
pool size=0;max pool size=20"

WHY IS IT LOOSING THE CREDENTIALS!!!!!!!!!!!!!!

PLEASE HELP.

If I request the page from the IIS Server it works, but
from any other maching IT DOESNT.

--------------------------------------------------------
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
Description: An unhandled exception occurred during the
execution of the current web request. Please review the
stack trace for more information about the error and where
it originated in the code.

Exception Details: System.Data.SqlClient.SqlException:
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

Source Error:


Line 78: strConn =
System.Configuration.ConfigurationSettings.AppSett ings.Get
(strConn);
Line 79: sqlConn = new SqlConnection
(strConn);
Line 80: sqlConn.Open();
Line 81: return sqlConn;
Line 82: }


Source File: F:\eClinics\Global.asax.cs Line: 80

Stack Trace:


[SqlException: Login failed for user 'NT
AUTHORITY\ANONYMOUS LOGON'.]
System.Data.SqlClient.ConnectionPool.GetConnection
(Boolean& isInTransaction) +472

System.Data.SqlClient.SqlConnectionPoolManager.Get PooledCon
nection(SqlConnectionString options, Boolean&
isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
eClinics.SQL.OpenSQLconn(SqlConnection sqlConn) in
F:\eClinics\Global.asax.cs:80

eClinics.Resource.Resource.ResourceCode.PopulateRe sourceGri
d() in
F:\eClinics\DataRepository\Resource\ResourceCode.a spx.cs:36
eClinics.Resource.Resource.ResourceCode.Page_Load
(Object sender, EventArgs e) in
F:\eClinics\DataRepository\Resource\ResourceCode.a spx.cs:66
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731




-----------------------------------------------------------
---------------------
Version Information: Microsoft .NET Framework
Version:1.1.4322.573; ASP.NET Version:1.1.4322.573

[Ken Schaefer]

If you are using Integrated Windows Authentication in IIS, then the
webserver never has the user's password, so it can't send it to another box.

You'll need to use Basic Authentication (preferably with SSL) so that the
webserver can send the user's name *and* password to SQL Server

-or-

You need Kerberos + Delegation (but apparently this has its cons as well
with Windows 2000 networks)

Cheers
Ken

"Silvia Brunet Jones" <sbrunet_jones@hotmail.com> wrote in message
news:007b01c34c82$6cbfe280$a401280a@phx.gbl...
: Ok I have this big problem again.
: I have my IIS Server in one maching and my SQL DB in
: another. It needs to stay this way.
: I am connection with windows authentication to IIS
:
: <authentication mode="Windows" />
: <identity impersonate="true" />
:
:
: and my connection string looks like this
:
: "Trusted_Connection=Yes;data source=NET_SERV_RS;integrated
: security=SSPI;initial
: catalog=RDBP1;pooling=true;connection lifetime=180;min
: pool size=0;max pool size=20"
:
: WHY IS IT LOOSING THE CREDENTIALS!!!!!!!!!!!!!!
:
: PLEASE HELP.
:
: If I request the page from the IIS Server it works, but
: from any other maching IT DOESNT.
:
: --------------------------------------------------------
: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
: Description: An unhandled exception occurred during the
: execution of the current web request. Please review the
: stack trace for more information about the error and where
: it originated in the code.
:
: Exception Details: System.Data.SqlClient.SqlException:
: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
:
: Source Error:
:
:
: Line 78: strConn =
: System.Configuration.ConfigurationSettings.AppSett ings.Get
: (strConn);
: Line 79: sqlConn = new SqlConnection
: (strConn);
: Line 80: sqlConn.Open();
: Line 81: return sqlConn;
: Line 82: }
:
:
: Source File: F:\eClinics\Global.asax.cs Line: 80
:
: Stack Trace:
:
:
: [SqlException: Login failed for user 'NT
: AUTHORITY\ANONYMOUS LOGON'.]
: System.Data.SqlClient.ConnectionPool.GetConnection
: (Boolean& isInTransaction) +472
:
: System.Data.SqlClient.SqlConnectionPoolManager.Get PooledCon
: nection(SqlConnectionString options, Boolean&
: isInTransaction) +372
: System.Data.SqlClient.SqlConnection.Open() +384
: eClinics.SQL.OpenSQLconn(SqlConnection sqlConn) in
: F:\eClinics\Global.asax.cs:80
:
: eClinics.Resource.Resource.ResourceCode.PopulateRe sourceGri
: d() in
: F:\eClinics\DataRepository\Resource\ResourceCode.a spx.cs:36
: eClinics.Resource.Resource.ResourceCode.Page_Load
: (Object sender, EventArgs e) in
: F:\eClinics\DataRepository\Resource\ResourceCode.a spx.cs:66
: System.Web.UI.Control.OnLoad(EventArgs e) +67
: System.Web.UI.Control.LoadRecursive() +35
: System.Web.UI.Page.ProcessRequestMain() +731
:
:
:
:
: -----------------------------------------------------------
: ---------------------
: Version Information: Microsoft .NET Framework
: Version:1.1.4322.573; ASP.NET Version:1.1.4322.573