login error from SELF\ASPNET

Hi all,

I am getting one error while compiling the asp.net application ie

"Login failed for user 'SELF\ASPNET' (SELF is the name of my computer)

please tell me what exactly the problem or what exactly the solution.

With Regards
SreenugIf you are getting this error when trying to connect to the database, then you need to give permissions to aspnet user on your sql server
Hi,
Just in case you are using Windows Server 2003; ASPNET is replaced by 'NETWORK SERVICE' in win2k3 with IIS 6.0 as the default asp.net application user name. I created a SQL Server login 'NT AUTHORITY\NETWORK SERVICE' to access my MSDE DBs on a local machine running win2k3, and was able to access them.
you have two options!

First: In EnterpriseManager, you create a ASPNET user. (integrated security)

Secod: You can used the same user of SQL, which you install SQL (user id, password)