login failed

hi

using ASP.NET 1.1 and SQL Server 2000 EE.

I'm unable to open a connection locally. I always get "login failed for user NT AUTHORITY\NETWORK SERVICE"

integrated windows authentication and annoymous access have been enabled in IIS (running WS2003)

any ideas what the problem is and how I can add this account? I cant find this account in SQL ServerNo, the problem is that you are not specifying a user name and password on your connection string.

Use the same user and password of an account you have set up in your SQL Server.
im afraid you are incorrect
I resolved this issue by adding the IIS_WPG account in SQL
Also previously you did not have to specify a username/password if you did not want to use specific account but standard Windows Authentication :)
You could've solved this by allowing identity impersonate.
true
I remember i didnt need to do this before but..oh well :)