access data in remote SQL server with trusted authority

I have two win2003 servers. One is IIS and the another is SQL server. I
can use MyConnection=new
SqlConnection("server=SQLServerName;database=myDBName;UID=sa;PWD= mypwd")
to access my data. But I can not use MyConnection=new
SqlConnection("server=SQLServerName;database=myDBName;Integrated
Security=SSPI") to access it. If I put both IIS and SQL Server in one
machine, I can do anything. How can I do something to allow trusted
authority work ?

ThanksYou might find these KB articles (or one of the ones they link to)
useful:

http://support.microsoft.com/defaul...kb;en-us;316989
http://support.microsoft.com/defaul...kb;en-us;247931

If these don't help, I suggest you clarify what you mean by "can not
use" - do you get a specific error message?

Simonsql