>-----Original Message-----
>hi
>
>i have a problem with database access (SQL Server/MSDE)=20
on my production
>server.
>
>the asp.net web app works fine in test.
>
>on the production server, it won't connect to the=20
database!
>
>i'm pretty sure i have set up the ASPNET login correctly,=20
with permissions
>identical to my test system
>
>it only fails when trying to use a Trusted connection for=20
ASPNET - using an
>SQL connection.for use 'sa' works just fine.
>
>the only clue i have is a SQL security log entry=20
of "login failed for 'NT
>AUTHORITY\NETWORK SERVICE'"
>
>Thanks
>Ian
>
>
>.