IIS Sql Server ASP NET 2 authentication

[digbydog]

Hi,

we are creating an intranet where iis and sql server reside on different
machines. We have been able to use identityimpersonate=true with windows
authentication etc when iis and sql server reside on the same machine but
cannot get this to work when they are on different machines.

I read an article about using kerberos authentication - is this the only way
to authenticate when iis and sql server are on different machines ? Can
anyone point me in the right direction please ?

thanks

 

[Consultant]

you need to have the iis machines computer account trusted for delegation,
within active directory. you will also have to setup an spn for it.

 

[digbydog]

thank you for that will progress and see how it all goes.

 

[Salah Mrad]

How did you use "identityimpersonate" with windows authentication?
i failed to use them..
would you please put the required steps and conditions, sorry but i'm
bigener.
thanks in advance.