Confused about which webserver to use(closed gave up)

I tried that it still is the same. I would like to thank everyone who has helped so far. I feel alot closer to a solution now. Hopefully, we can get that last part solved.

I removed the identity impersonate in the web config just to see what it would do and I get the exact same error.

I just created a user called test with password Password123. I added the user to the sql and gave the user full rights to the SQL northwind database. I then editted the connection string and added uid='test;pwd='Password123'. This of course failed and told me login failed for user test. I then tried adding the domain to the uid and same results. I have no idea what to try next, anyone?

I think my biggest problem is that I am unsure of how the security and authentication all fits together. I keep using the webconfig impersonate, the connectionstring with uid and pwd, add multiple logins on the sql, and never really being sure whether I am in windows, mixed mode, or what ever else modes there are. What I would like is for any user to be able to open the webpage and save it to the sql. ANy ideas on what settings I should have for all of the above? Or if you know of a webpage that describes how to setup for anom users, intranet users, and pers you want to authenticate - I am sure they are all different.

I found a really nice webpage on how to determine who is running the page. Its at http://support.microsoft.com/kb/315736/EN-US/ and it basically uses this code

VB Code:

Imports System.Security
                        
Add the following code to the Page_Load event procedure:Dim authUserName As String
Dim aspUserName As String
authUserName = User.Identity.Name
aspUserName = Principal.WindowsIdentity.GetCurrent.Name
authUserPrincipalLabel.Text = "You are: " & authUserName
aspPrincipalLabel.Text = "This page runs as: " & aspUserName

When I run it on my server I get, no authUserName but the page runs as NT AUTHORITY/ NETWORK SERVICE. Does this help anyone help me get any further? I think I am drowning here.