Create SharePoint 2010 Web Application using FBA (forms Based Authentication)

This blog to illustrate how to create a Forms Based Authentication for SharePoint 2010 using SQL database as users repository ,  users will be authenticated from SQL database instead of active directory

1. From Central Administration –> Manage Web Application , create a new web application

image

In below option make sure to check NTLM and Forms Based Authentication this will allow users form active directory and from SQL to login ,

image

note: enter a name for the membership provider  and Role manage , these names will be used later on. (you can choose any name).

2. Create SQL Database , from any server (like App servers) that has access to the database server run the aspnet_regsql .exe:

image

· Select to configure database

image

· Select the SQl server db name , and provide a proper name for the database , this database will be used to host SharePoint users :

image

3. Create an admin account under this database to be used to connect to FBA_Users DB , From inside SQL management studio –> Security –> new login

image

· From General tab , enter password

image

· From users mapping place FBAadmin as db_owner for the FBA_Users DB:

4. you have to configure the FBA web application to use the SQL database as users’ repository for user management , On IIS for Each Front end Server WFE do the following:

a. Select the web application which you wish to configure:

image

b. Click on Connection String , create a connection string that points to the database we have just created:

image

c. Click on Providers , to create a new SQL provider :

image

Note: ignore the warning message.

d. Make sure that Roles is selected from features dropdown , then click add

image

e. Make sure to enter the same Role name ,you entered at the web application creation time in a previous step:

image

Note: application name should be “/” to indicate the root web.

f. To add new membership , select users form the feature dropdowns , then click add:

image

g. Place the membership provider name:

image

5. Do the same steps(from a-g) for the Secure store services, this will guide the secure store to authenticate users from SQL database as well.

image

6. you can optionally download from codePlex User Management webParts from http://sharepoint2010fba.codeplex.com/   which will help site admins to add/edit/delete users from inside SharePoint pages

image

 

7. By this the configuration is done , login to site collection , and assign permissions to SQL users from site permission

image

8. You can assign permissions to users from SQL membership provider as shown below:

image