SharePoint: configuring the FBA (Form Based Authentication) with the SqlMembershipProvider

Here is a guide to configure the FBA using the SqlMembershipProvider:

  1. create the membership database executing C:\Windows\Microsoft.NET\Framework64\v2.0.50727\aspnet_regsql.exe, then add the user executing the application pool as db_owner of the database;
  2. from the Central Administration, create the web application setting Claims Based Authentication and then enable the Form Based Authentication, giving SqlMembershipProvider as membership provider and SqlRoleProvider as role provider;
  3. modify the web.config of the Central Administration:
  4. add tags to the PeoplePickerWizard;
  5. add the RoleManager tag;
  6. add the Membership tag;
  7. add the connection string to the FBA database;
  8. add the users to the FBA database via IIS manager;
  9. modify the web.config the Security Token Service, found under %programfiles%\common files\Microsoft Shared\web server extensions\14\WebServices\SecurityToken, like for step 3;
  10. modify the web.config of the web application, like for step 3. 

And here are the links I've used to compile this guide:

  1. How To Configure Claim Based Authentication for SharePoint, Project Server 2010: clean guide with a lot of helpful images
  2. Configure Forms Based Authentication (FBA) with SharePoint 2010
  3. HOW TO:Forms Based Authentication (FBA) on SharePoint 2010
  4. Configuring Forms Based Authentication for SharePoint 2010 using IIS7
  5. Configuring FBA in SharePoint Server 2010

Add comment