SharePoint Foundation 2013 Forms Based Authentication (FBA)

Scenario

You need to have individual Forms Based Authentication (FBA) on several different Sharepoint Foundation 2013 Site Collections.

Solution

1. Run c:\windows\Microsoft.NET\Framework64\v4.0.30319\ aspnet_regsql.exe to set up Membership Database
2. Give Identity Running Sharepoint "db_owner" priveleges in MSSMS for the aspnetdb database.
3. Create a Dummy Website in IIS "MembershipConfig"
4. Install FBA for SharePoint 2013 - This allows management of users inside sharepoint
5. Edit machine.Config File
6. Configure Forms Auth in Sharepoint for Site Collection

Caveats

• Use SQL Authentication for ALL Connection Strings and DB User Accounts.

Resources

Here's a list of the resources I found which helped get the job done:

• Configuring Forms Based Authentication in SharePoint 2013 – Part 1 – Creating the Membership Database - Chris Coulson's Developer Notes
• Configuring SharePoint 2013 Forms-Based Authentication with SQLMemberShipProvider - Partner Technical Services Blog
• SharePoint 2013 Forms Based Authentication (FBA)- Random Technical Thoughts
• Configure Forms Based Authentication for SharePoint 2013 -
• Configuring claims and forms based authentication for use with a SQL provider in SharePoint 2010
• Easy-Bake Forms Based Authentication - SharePoint Voodoo
• Forms Based Authentication FBA In SharePoint 2010 Claims
• SharePoint 2013 FBA Pack