Need Help with SQL Server Authentication

From: Terry Olsen (tolsen64_at_hotmail.com)
Date: 05/26/04 

Date: Tue, 25 May 2004 22:19:30 -0600

Not sure if this question belongs here or in the aspnet group...but here
goes...

Ive got a Datagrid bound to a dataset connected to an SQL Server DB on the
local machine. I don't have any trouble creating the database using the SQL
Web Manager from Microsoft. Everything connects up just fine in design mode
using ASP.NET 2003, but when I try to view the web page I get...

---- Begin Error Message ------

Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Login failed for user
'NT AUTHORITY\NETWORK SERVICE'.

Source Error:

Line 76:
Line 77: Private Sub Button1_Click(ByVal sender As System.Object, ByVal
e As System.EventArgs) Handles Button1.Click
Line 78: SqlDataAdapter1.Fill(DsCenters1)
Line 79: DataGrid1.DataBind()
Line 80: End Sub

Source File: c:\inetpub\wwwroot\Lessons\HelloWeb\links.aspx.vb Line: 78

---- End Error Message ----

I've added "system\ASPNET" to the database users but that didn't help. Can
anyone help me get this working?

Thanks!
Terry