Monday, 3 October 2016

Configuring Forms Based Authentication in SharePoint 2016 – Part 2 – Creating the Membership Database

This article will help you out on Configuring Forms based authentication (FBA) in SharePoint 2016 it is very similar to SharePoint 2013.

I have broken down steps in  4 articles.

1. Configuring SharePoint

2. Creating Membership Database

3. Adding users to Membership Database

4. Editing the web.config files.

 So lets get started :)

Part 2 – Creating the Membership Database

 When we configure FBA for SharePoint we need a place to store all our usernames and passwords.
ASP.Net comes with a tool which we can use to create a membership database to store logon information.

Steps to create membership database.

  • Navigate to "C:\Windows\Microsoft.NET\Framework64\v4.0.30319"
  • Run application "aspnet_regsql.exe"
  •  Welcome screen will appear.Click Next
  •  Select “Configure SQL Server for application services” option and click Next.


  •  Enter the name of your server and your authentication information.I have selected windows authentication as i have single server farm.My administrator account has full access over SQL Server.Click Next

  •  Confirm your settings and click Next
  • The database has been created. Click finish.

    • Now we have to add the Application Pool that runs the web application and give it required permission . I have used Sutta\Administrator as my application pool name. 
    • Open up SQL Management Studio, Expand the database we created and expand Security
    • Right click Users and add a new User
    • User Type = Windows User
    • User name = choose <yourAppPoolAccountName>
    • Login name = browse and choose the login name

    •  Now Click on Owned Schemas and choose the following.
      • aspnet_Membership_FullAccess
      • aspnet_Persolalization_FullAccess
      • aspnet_Profile_FullAccess
      • aspnet_Roles_FullAccess
      • aspnet_WebEvent_FullAccess

    We are done with Part-2.Now, we will move to part 3 which is "Adding users to Membership Database".

    Happy SharePointing :)

No comments:

Post a Comment