sql server database access problem

[Ian]

hi

i have a problem with database access (SQL Server/MSDE) on my production
server.

the asp.net web app works fine in test.

on the production server, it won't connect to the database!

i'm pretty sure i have set up the ASPNET login correctly, with permissions
identical to my test system

it only fails when trying to use a Trusted connection for ASPNET - using an
SQL connection.for use 'sa' works just fine.

the only clue i have is a SQL security log entry of "login failed for 'NT
AUTHORITY\NETWORK SERVICE'"

Thanks
Ian