How to Add ASPNET account to your database

This is the error message "Login failed for user 'SUSHMA\ASPNET'. "

I am Building a Data Form that displays data from a single table- the Customers table in the Northwind sample Database.

I have Visual Studio.Net 1.0 and SQL Server 2000.

So I feel that I need to add an ASPNET account to my database.

Please could someone tell me if this could solve the problem, if so

please could you tell me how to Add an ASPNET account to my database?

Thank you

This thread has instructions on how to grant database access to a user account.
http://forums.asp.net/875897/ShowPost.aspx
|||

Hi,

Use Enterprise Manager (in SQL Server) to look at the users and groups for the database in question. If you don't see ASPNET there, you can add it, if it is there, it may be that it doesn't have sufficient permissions to do what you are asking it to do. The other thing to check applies if you are using IIS 6 (Win2k3 Server). In this case, ASP.NET uses NETWORK SERVICE, rather than ASPNET as the default worker process.

Hope it helps.