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 :)