Re: Need Help with SQL Server Authentication

From: Miha Markic [MVP C#] (miha)
Date: 05/26/04 

Date: Wed, 26 May 2004 11:08:25 +0200

Hi Terry,

Does this thread help?
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&threadm=OaF4P0t5DHA.3548%40TK2MSFTNGP11.phx.gbl&rnum=4&prev=/groups%3Fas_q%3D%27NT%2520AUTHORITY%255CNETWORK%2520SERVICE%27%26safe%3Dimages%26ie%3DUTF-8%26as_ugroup%3D*adonet*%26lr%3D%26hl%3Den 

-- 
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com
"Terry Olsen" <tolsen64@hotmail.com> wrote in message
news:uNbWditQEHA.1340@TK2MSFTNGP12.phx.gbl...
> 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
>
>