how to create ASPNET user in SQL Server 2000

Respected Members,

I have a question, when our aspx page is trying to access the SQL Server 2000 database than before this do we have to creaete a user with the name of ASPNET in SQL Server 2000, or without creating this paticular user(its the default user of ASP.NET account) our aspx pages can also access the SQL Server 2000,I have already SQL Server 2000 running in "SQL Server Authentication Mode" so while creating the user do I have to create it in "Windows Authentication" or "SQL Server Authentication", can you provide some link where I could find complete steps for craeting the ASPNET user or if some one can tell all the steps in details here.

This site has some good video tutorials for handling security in both ASP and SQL Server.

http://www.asp.net/learn/videos/default.aspx?tabid=63

|||Thanks for your reply, the site was really good,but I did'nt found any thing relevant to my question on this web site, do you have some idea about any other resources.|||

It seemed to me, perhaps I'm wrong, that the following video tutorials at that site are relevant to your task. ( realize that you indicated you are using SQL Server 2000 (which is a mistake -you should be using SQL Server 2005), but the concepts are basically the same.

And of course, you could refer to Books Online, the definitive source for SQL Server information.

From the “How Do I?” with ASP.NET section:

#7 | How Do I: Secure my Site using Membership and Roles?#9 | How Do I: Create a Full-Featured Customer Login Portal?

From the SQL Server 2005 Express for Beginners section:#7 | Understanding Security and Network Connectivity#8 | Connecting your Web Application to SQL Server 2005 Express Edition

From the Videos for ASP.NET 2.0 Beginners section:#9 | Lesson 9: Securing your Web Site with Membership and Login Controls