So you’re thinking that you might be interested in going down the path of Claims Authentication with SharePoint 2010 – I mean, it’s hip and new and a fun thing to do right?
In reality there are a lot of great things about claims and doors that it opens for federating with other applications around throughout the web that could not otherwise be done.
If you’re interested in Claims, definitely recommend Microsoft’s book – “A Guide to Claims-Based Identity and Access Control”.
But let’s say you’re already going down the path of Claims, but you’re done with Active Directory, and looking to just use SQL server? Not a problem, Microsoft has a handy document to help walk you through the configuration and setup titled, “Claims Walkthrough: Creating Forms-Based Authentication for Claims-Based Web Applications Using ASP.NET SQL Membership and Role Providers”.
Definitely a handy guide to digging deep into how to configure SQL for CBA and developing your solution to meet your needs.