firstly i would use the membership provider given with .net framework2 and VS2005.
Then you can create the tables and everything needed in the database using the aspnet_regsql program that comes with the .net framework (it is in the framework folder on your pc just do a search).
Then you can use webconfig to put your provider information and use the login tools etc with little or no code on your behalf.