Best option is asp.net membership.
you will successfully resolve the issues regarding tablelocks or transaction dead locks.
1.Setup ASP.NET Membership provider database using Microsoft SQL server 2005
2.Create user
3.Create Role Add user in Role
4.Provider Role based security to your application
5.Redirecting authorized users to see his web section to which he is authorized to see
6.Password recovery control and configuration.
7.Single Sign in / single login / single signin
Follow below link for more details:
ASP.NET Membership