"Windows Authentication" is very complicated !

Hi every members,

I am totally frusrated with using Windows Authentication in ASP.NET 3.5, here is what I have done :

(1)Web server and SQL server are 2 separate machines

(2)Web server : Win Server 2003 R2, Standard x64 Edition

(3)SQL Server 2005 Standard x64, 9.0.3054

(4)Web.config :

<add name="ABC" connectionString="Data Source=193.167.1.143;Initial Catalog=ABC;Trusted_Connection=Yes;" />

<add name="ABC" connectionString="Data Source=193.167.1.143;Initial Catalog=ABC;Integrated Security=SSPI;" />,

I have tried both of them, but both of them failed.

Before that, we used SQL Server auth., it worked fine, no problem :

<add connectionString="Data Source=193.167.1.143;Initial Catalog=ABC;User ID=XXX;Password=yyy" name="ABC" providerName="System.Data.SqlClient" />

 My Web.config file already had :

< ...