SQL Connect on another Machine

[bobisto]

I'm creating web project. I want to connect to Sql server on another machine but i've problem with connection sting. If I'm connecting on my machine then there is no problem. On my machine am connecting as 'Commp.name'\ASPNET and the connection string is:
server='localhost'; trusted_connection=true; Database='PLP'

I've tried everyting but I always get an error:
[SqlException: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.]
I've access on the another machine and sql server
Please help!!!

 

[logi2000]

check if the ASP.net internet user has access or rights enabled in the other computer.

 

[bobisto]

Yes it does have, but sql server don't have a permission for ASPNET. I think that user is "COMPUTERNAME"\ASPNET so that is a problem!.
I've read a post from the past and they think that sql server on other machine must have SQL Authentication. It has only Windows authentication.
What you think about this?
Help please!!!

 

[logi2000]

put the impersionate authentication line in the web config file.

have you solved this problem already ?