IIS+SQL using Integrated Windows Authentication

Hi, All

I'm using the Integrated Windows Authentication both of IIS and SQL.
The two server are not based on the same machine.
My ASP.NET application using the "SERVER=LIUFENG2;DATABASE=CESRS;INTEGRATED
SECURITY=SSPI;POOLING=TRUE" to connect SQL, and trun on "<identity
impersonate="true" />" in Web.config.

I got the message "Login failed for user '(null)'." when
SqlConnection.Open().

The two way I found to resolve that:
1. <identity impersonate="true" userName="someone" password="********" />
2. Operate with Active Directory to allow delegate for client.

Any more answers for the "double-hop"?

--


Thanks,
LiuFeng
MSN Messenger: blindlf.TakeThisOut@hotmail.com

Other options:

a) Use Basic Authentication + SSL

Cheers
Ken


"Liu Feng" <blind.l.f RemoveThis @yeah.net> wrote in message
news:uyDtxcX%23FHA.252@TK2MSFTNGP15.phx.gbl...
: Hi, All
:
: I'm using the Integrated Windows Authentication both of IIS and SQL.
: The two server are not based on the same machine.
: My ASP.NET application using the
"SERVER=LIUFENG2;DATABASE=CESRS;INTEGRATED
: SECURITY=SSPI;POOLING=TRUE" to connect SQL, and trun on "<identity
: impersonate="true" />" in Web.config.
:
: I got the message "Login failed for user '(null)'." when
: SqlConnection.Open().
:
: The two way I found to resolve that:
: 1. <identity impersonate="true" userName="someone" password="********" />
: 2. Operate with Active Directory to allow delegate for client.
:
: Any more answers for the "double-hop"?
:
: --
:
:
: Thanks,
: LiuFeng
: MSN Messenger: blindlf RemoveThis @hotmail.com
:
: