Asp.net and SQL login failures

[Larry]

I'm getting a login error from SQL when I try to run my asp.net form. The
error reads :

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

Now I was under the impression that aspx pages ran under the username of
"machine\ASPUSER" or possible assumes the user credentials of the currently
logged in user of a non-anomomous user site.

I've just setting up this server so I've must of missed a setting someplace
(I'm using Windows 2003 + SQL 2000 without ActiveDirectory; if this info
helps). I used Visual Studio to set up the tables and its wizards to create
the stored procedures.

-Larry

 

[WJ]

Give 'NT AUTHORITY\NETWORK SERVICE' account SQl access (the database that
your webapplication is after), then you should be OK.

John

 

[Larry]

I'd like to but this user name or group does not exist on my server (at
least not in my "local users and groups" management tool.

I hope you might have some other ideas.

-Larry

 

[Guest]

Make sure that the IUSR user (usually IUSR<computer name> has access rights
to the database as well. Also, depending on what you are doing, there are
several system accounts that will need access from time to time if you are
going to require some work in relation to the file system etc...