I found this very useful guide on how to configure FBA for SharePoint 2010.
Problem
Everything worked fine except for one, I could not add any .Net User to the SQL database.
Solution
The only thing that I had to add to get it to work completely was to modify the MembershipProvider under the FBA Web Application as follows:
- Open Web.config
- Look for the section and add minRequiredPasswordLength=”7″, otherwise you may have issues adding users.
<providers>
<add name=”i” type=”Microsoft.SharePoint.Administration.Claims.SPClaimsAuthMembershipProvider, Microsoft.SharePoint, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c” />
<add name=”FBAMembershipProvider” type=”System.Web.Security.SqlMembershipProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a” connectionStringName=”FBA” minRequiredPasswordLength=”7″ enablePasswordReset=”true” enablePasswordRetrieval=”false” passwordFormat=”Clear” requiresQuestionAndAnswer=”false” requiresUniqueEmail=”false” applicationName=”/” />
</providers>
