I would suggest you to go through the great article - ASP.NET authentication and authorization
] and learn all the concepts.
Then you will able to use the default Asp.Net Membership.
For setting up the database for that, follow the steps provided in the article or implement the quick solution
] to do it directly from Visual Studio.