Asp.Net provide users forms authentication for login system. It contains database schemas, sample code, stored procedure, views, database roles. C# code is very simple, however database setup takes lots of time. In additional you have to deploy database correctly, looks like contains bug if you just get all the script, stored procedure, views, roles and etc. Asp.net 3 login system works if just attach the mdf file. Anyway, this blog shows you have to enable simple login authentication system by using asp.net 3.
Following is diagram for login system, microsoft provide.
Read more...April 1st, 2014