error in sql

Sir,
I encounter the error page when tried to display the
data from northwind database in a datagrid in aspx
application. The error page I get is as follows:
server error in '/myview' application
Login failed for user 'NT Authority\Network Service'
Exception details :System.Data.SqlClient.SqlException:
Login failed for user 'NT Authority\Network Service'
Please give a good solution for this.
I'm using sql server 2000 in .net 2003 serverThe most complete resource on securing asp.net when working with SQL
Server is the best practices whitepaper, which you can download at
http://www.microsoft.com/downloads/release.asp?ReleaseID=44047. It
sounds like you have system instead of machine specified as the
processmodel element (a security no-no). Open the Machine.config file
in Notepad and change the userName attribute to MACHINE. Save and then
enable the ASPNET account in SQL Server and grant it membership in any
roles you need.
-- Mary
MCW Technologies
http://www.mcwtech.com
On Tue, 13 Jan 2004 03:50:11 -0800, "ramadevi"
<anonymous@.discussions.microsoft.com> wrote:
>Sir,
> I encounter the error page when tried to display the
>data from northwind database in a datagrid in aspx
>application. The error page I get is as follows:
> server error in '/myview' application
> Login failed for user 'NT Authority\Network Service'
>Exception details :System.Data.SqlClient.SqlException:
> Login failed for user 'NT Authority\Network Service'
>
>Please give a good solution for this.
> I'm using sql server 2000 in .net 2003 server