Step by step – Enable Form based authentication in SharePoint 2010 or SharePoint 2013 (step by step FBA / Claims based authentication)

Finally done 🙂

I was planning to implement and write a article with screen shots about claims from long time.

Follow below steps to enable Form based authentication in SharePoint 2010 or SharePoint 2013.

 

  1. Create User database Table
(Open Command prompt and navigate to C:\Windows\Microsoft.NET\Framework64\v4.0.30319 and then run aspnet_regsql command)
Command prompt screen to create database using aspnet_regsql

(Follow the wizard with proper inputs)

Create Membership Database wizard SQL

 

Create Membership Database wizard SQL

 

Create Membership Database wizard SQL

 

Create Membership Database wizard SQL

 

Create Membership Database wizard SQL success screen
2. IIS Configuration – Add Connection String

 

IIS 7 add connection

 

IIS 7 add connection

 

IIS 7 add connection

3. Add Provider at server level

IIS 7 add provider

 

IIS 7 add provider

 

IIS 7 add .NET Roles

 

IIS 7 add .NET Users

4. Add Provider at Secure token service level

Add provider for Secured Token Service SharePoint

 

Add Provider in IIS 7 SharePoint

 

Add Provider in IIS 7 SharePoint
5. Add Web.config entries for people picker

 

Web.config central admin

6. Create new web app with claims authentication Or if you have web app with claims created then map the membership providers.

Create New Web Application SharePoint 2010

7. Add user in database

Add User IIS 7

 

Add User IIS 7

 

Add User IIS 7
8. give permission to newly added user
Edit Authentication SP CA 2010

 

Edit Authentication SharePoint Central Admin 2010

 

Claims Sign on Screen SharePoint 2010

 

Give Permission Screen SharePoint 2010
9. Login with FBA

 

FBA Login Screen SharePoint

 

User from Database logged in SharePoint 2010

10. Remove anonymous access

Edit Authentication SharePoint 2010

 

Edit Authentication SharePoint 2010

11. Login with user from database

SQL membership Log in user SharePoint 2010

🙂 Done!!!!

Leave a comment