URGENTT: Login failed for user '(null)' - ASP.NET

[JustRun]

Hi ,

I use .NET 2.xx for developing an intranet site, The IIS (my application) on Server1 (Domain controller) the SQl server 2000 on Server2.
and both servers running through windows 2003.

I did the following steps,

1- Create Domain account on the Domain controller (Server1\ASPNET)
2- Made new login on the SQL, and created new user on the database I want to access, then I gave that user permissions to access my stored procedure and views.
User Name: Server1\ASPNET
Login Name: Server1\ASPNET
3- enabled the Network Service in the Temporary ASP.NET Files

Actually I did many other things that i can't remember just to make that application work
I still have that stubid error:
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection :(.

I'm wondering Should I replace ASPNET with NETWORKSERVICE cause it windows 2003 !!!

Please answer me I've spend 4 days trying to publish this site with no use !!

[DrBunchman]

Hi JustRun,

This is a classic ASP forum and you're question is probably better suited to the .NET forum or the IIS forum. A quick google gave me this but i'm sure you've probably googled this problem enough times already.

Good luck finding a solution.

Dr B