SharePoint 2016: Forms Based Authentication – Part 2

In the previous article SharePoint 2016: Forms Based Authentication – Part 1 of this series on implementing FBA with SharePoint we saw the execution of Steps 1 & 2 for the process.

In this article, we are going to see the execution of Steps 3 & 4 and for the sake of quick review am putting up the process diagram again in here.

Process Diagram

https://howtodowithsharepoint.files.wordpress.com/2016/06/16.png?w=800

Step 3: Configure IIS

• Start IIS Manager with Admin rights

https://howtodowithsharepoint.files.wordpress.com/2016/06/22.png?w=800

• Select IIS Server Name on the left navigation
• Click on the “Connection Strings”

https://howtodowithsharepoint.files.wordpress.com/2016/06/32.png?w=800

• Click on Add

https://howtodowithsharepoint.files.wordpress.com/2016/06/42.png?w=800

• On the “Add Connection String” Screen
• Enter the name of Connection String
• Enter SQL Server Instance Name
• Enter Database Name
• Verify the Connection String and make sure it is correctly build up

https://howtodowithsharepoint.files.wordpress.com/2016/06/52.png?w=800

Once done with the process we can see the Connection String created

https://howtodowithsharepoint.files.wordpress.com/2016/06/62.png?w=800

Select IIS Server Name on the left navigation and click the “Providers”

https://howtodowithsharepoint.files.wordpress.com/2016/06/72.png?w=800

• Select Feature “.Net Roles” from the drop-down
• Click Add

https://howtodowithsharepoint.files.wordpress.com/2016/06/82.png?w=800

• On the “Add Provider”
• Select Type as “SqlRoleProvider”
• Enter Name as appropriate
• Enter Connection String Name as appropriate
• Enter Application Name as “/”
• Click OK

https://howtodowithsharepoint.files.wordpress.com/2016/06/92.png?w=800

• Select Feature “.Net Users” from the drop-down
• Click Add

https://howtodowithsharepoint.files.wordpress.com/2016/06/102.png?w=800

• On the “Add Provider” Screen
• Select Type as “SqlMembershipProvider”
• Enter Name as appropriate
• Configure behavior of the Membership Provider
• Choose Connection String Name we created earlier under Data Section
• Scroll down to configure more settings

https://howtodowithsharepoint.files.wordpress.com/2016/06/112.png?w=800

Enter “/” as Application Name under General Section

https://howtodowithsharepoint.files.wordpress.com/2016/06/122.png?w=800

• Expand the Web Application from the left navigation
• Click on the “Providers” from the right-hand side

https://howtodowithsharepoint.files.wordpress.com/2016/06/132.png?w=800

Configure “Providers” (Roles & Membership Providers) as shown above since the steps are exactly same so am not repeating it.

Putting up the screen shots here for your quick reference

https://howtodowithsharepoint.files.wordpress.com/2016/06/142.png?w=800https://howtodowithsharepoint.files.wordpress.com/2016/06/151.png?w=800https://howtodowithsharepoint.files.wordpress.com/2016/06/161.png?w=800https://howtodowithsharepoint.files.wordpress.com/2016/06/17.png?w=800https://howtodowithsharepoint.files.wordpress.com/2016/06/18.png?w=800

Step 4: Modify Web.Config

In the IIS select the Web Application that you want to implement with FBA

• Click “Explore”

https://howtodowithsharepoint.files.wordpress.com/2016/06/19.png?w=800

This will open the Virtual Directory for the Web Application

Edit the Web.Config file for the Web Application using Visual Studio

https://howtodowithsharepoint.files.wordpress.com/2016/06/20.png?w=800

Now locate “PeoplePickerWildcards” Section as shown below

https://howtodowithsharepoint.files.wordpress.com/2016/06/211.png?w=800

Specify the name of membership provider “SPMembership” that we have configured in steps above

https://howtodowithsharepoint.files.wordpress.com/2016/06/221.png?w=800

With this, we are all done for this demo.

In this article, we have covered Step 3 & 4. We will look for Step 5 in an upcoming article on Configuring FBA for SharePoint as follows-
SHAREPOINT 2016: FORMS BASED AUTHENTICATION – PART 3

Stay tuned.

Return to Top