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

[Fredrik Normén NSQUARED]

This would not work if the Database is not installed on
the same machine as the Web Server, beause the ASPNET is a
local account. A local account could only be used on its
own machine.

/Fredrik Normén NSQUARED2

>-----Original Message-----
>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
>
>
>.
>