asp.net sql connection

[Guest]

In my web app, i have my connection string using trusted_connnection=true and
I can connect to the database server from my machine, when I make the change
to the web.config file to the web app on the web server I get this error
message when trying to connect to the database
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'

why can I connect from my box (I had another developer test the web app from
my machine and he to can connect fine) but when I try to connect from the web
server I get the error message? What needs to be done on the web server that
I'm missing?

 

[Guest]

i got it to work, I had to change it to intergrated instead in the connection
string.