I found this very useful guide on how to configure FBA for SharePoint 2010.

http://donalconlon.wordpress.com/2010/02/23/configuring-forms-base-authentication-for-sharepoint-2010-using-iis7/

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:

  1. Open Web.config
  2. 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>
 

Tagged: ,