I'm realatively new to ASP.net and I'm trying to figure out the best practice for managing users for a web site.
I want to know how to create a login screen where new users register by creating a user account and PW in a SQL DB and then log them on. Question.. should I create a new user within SQL server or should I store the accounts as records in a table?
Also, when this function is performed I asume I should use a stored account with administer rights to open the database first, then create the user.
I need sample code with comments explainging what's going on. this way i can modify it to work on my machine and debug it and watch the process in order to learn.
how is this process most widely handled?