SharePoint 2007 Forms Authentication with Sql Server

Dan Attis has two great articles about configuring forms authentication against SQL Server with MOSS.

Part one - Configuring Forms Authentication with SharePoint
http://devcow.com/blogs/jdattis/archive/2007/02/23/Office_SharePoint_Server_2007_Forms_Based_Authentication_FBA_Walkthrough_Part_1.aspx

Part two - Configuring Forms Authentication with MySites
http://devcow.com/blogs/jdattis/archive/2007/03/01/Office_SharePoint_Server_2007_Forms_Based_Authentication_FBA_w_MySites_Walkthrough_Part_2.aspx
Points to note:

• If you cant resolve your SQL users in the Central Administration you need to grant database access to the identity (user) that runs under the application pool account and make sure you have added Membership provider and Role Manager to the central administration web.config.
• My deployment was configured intially for authentication with Active Directory. My SSP Admin site couldn't resolve the SQL users. I resolved this by creating a web application that extended the SSP Admin site to another port, setting the authentication to forms and specifying the Membership provider and Role Manager.

There's a useful tool on CodePlex for managing the Forms Based Authentication users in SharePoint, please see http://www.codeplex.com/fba