Authentication problem

Hi,

I've always developed using connectionstrings with sql authentication but this time i need to do it with windows authentication

i have an IIS server in one city, and many sql servers in different cities
i can connect to any sql server using windows authentication in sql management studio
i can even connect to any sql server in visual studio (http://localhost:49161/InicioSesion.aspx)
but if i try to do it here: http://localhost/InicioSesion.aspx i get the "Error de inicio de sesión del usuario 'NT AUTHORITY\ANONYMOUS LOGON'."

if i change the ApplicationPoolIdentity to my windows account in the anonymous logon option (IIS) it works but i don't want everybody to be using my account instead of theirs

what should i do?
thanks in advance

windows authentication uses the Authentication of the System requesting the SQL connection.. IE. the IIS server.. You could try setting up IIS to authenticate the every user (Do not allow Anon logins)...

Quote:

---

Originally Posted by GremlinSA

windows authentication uses the Authentication of the System requesting the SQL connection.. IE. the IIS server.. You could try setting up IIS to authenticate the every user (Do not allow Anon logins)...

---

I disabled anonymous authentication and it doesn't work either
i've read about identity impersonate but no success so far

the only thing that works is removing ApplicationPoolIdentity and adding my windows account instead