Can't Login SQL from ASP.NET applications

[Herr Lucifer]

I have SQL 2000 installed and it works fine with windows applications on my
hard drive. The problem is that I can't access the same databases with the
same login permission from a web application ( using NT integrated
authority). The error says:
Login failed for user 'HERRLUCIFER\ASPNET'.
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
'HERRLUCIFER\ASPNET'.

Line 110: 'Put user code to initialize the page here
Line 111: If Not Me.IsPostBack Then
Line 112: DACustomers.Fill(DsCustomerNames1, "Customers")
<<---error (red) line
Line 113: DataGrid1.DataBind()
Line 114: End If

 

[Riki]

I have SQL 2000 installed and it works fine with windows applications
on my hard drive. The problem is that I can't access the same
databases with the same login permission from a web application (
using NT integrated authority). The error says:
Login failed for user 'HERRLUCIFER\ASPNET'.
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 'HERRLUCIFER\ASPNET'.

Line 110: 'Put user code to initialize the page here
Line 111: If Not Me.IsPostBack Then
Line 112: DACustomers.Fill(DsCustomerNames1, "Customers")
<<---error (red) line
Line 113: DataGrid1.DataBind()
Line 114: End If

2 solutions:
1) Add the ASPNET user as a login to your SQL Server, and give it
access to your database.
2) Turn impersonation on in web.config and run your application
with the identity of the logged on user.