Close

BLOGS

Setting up FBA Authentication in SharePoint

Forms Based Authentication (FBA)

Forms Based Authentication is an identity management system based on ASP.NET membership and role provider authentication. Forms Based Authentication in SharePoint 2013 is a claims-based authentication method. In the normal scenario we authenticate to SharePoint
using AD, but here we are using a separate SQL DB for authentication.

Authentication types and methods in SharePoint 2013

  1. Windows authentication
  2. Forms-based authentication
  3. SAML token-based authentication


Configuration Steps:

Create a separate database

  1. Open the path as in the following:
  2. C:\Windows\Microsoft.NET\Framework\v4.0.30319 and run the exe aspnet_regsql.exe
  3. Otherwise we can run this exe using a Visual Studio command prompt.
  4. Click on the Next button.
  5. Here select the first option Configure SQL Server for application services.
  6. Enter the server name and database name. If you do not specify the dB name then it creates the dB with the name aspnetdb.
  7. Click on the next button.
  8. Click on Finish, now the dB is created.

Our database creation has been completed and next we need to add users to the same db. For this we can use Visual Studio or IIS.

Using IIS

  1. Add a new website in IIS.
  2. Click on the Connection string.
  3. Enter the connection name, server name and database name here.
  4. Enable the Forms Authentication.
  5. Click on the providers.
  6. Create a .Net Role here.
  7. Create a .Net User.
  8. Click on the Finish button. Now a user is created in the database.

Add users using Visual Studio

  1. Create a website and edit the webconfig and click on the Website tab.
  2. Click on the ASP.NET Configuration.
  3. Here we have the option to create a new user and roles.
  4. The next step is to make some changes in Central Admin, Security Token Services.
  5. For this we need to directly change some options through IIS or we can edit the values in the webconfig.

Create a SQL connection for SharePoint Central Admin site as in the following:

  1. Create the Membership provider and Role provider.
  2. The same things need to be done in the Security Token Service Application website.
  3. Create the connection string, memberprovider and role provider.
  4. The next step is to create a new web application.
  5. Open Central Admin tehn select Application Management => Manage web Application.
  6. Click on the New button.
  7. Here we have the changes from a normal web application only in the Authentication part.

Check the Enable Forms Based Authentication and enter the Membership and Role provider name. After this we need to create a site collection. Now our new web application and site are created and we need to add a connection string and provider name for the new web application. Edit the web config for New Web Application, Central admin and Security Token Services Application site.

Now open the site. It shows two options for logging.

Now we are logged in using Windows Authentication. Set the permission for the newly created user.

Go to Site Settings => Site permission 

Here we will get the users both AD and forms authentication. Here it's showing one of my AD accounts and an other from the database.

Next we are logging with Forms Authentication.

Print
Posted: Mar 7, 2018,
Categories: SharePoint,
Comments: 0,
Author: Urish Arora
Rate this article:
5.0

Urish AroraUrish Arora

Other posts by Urish Arora

, Contact author

Please login or register to post comments.

Name:
Email:
Subject:
Message:
x

SEARCH

Categories

Subscribe to our blog

«March 2019»
MonTueWedThuFriSatSun
25262728123
45678910
11121314151617
18192021222324
25262728293031
1234567

  • Featured Posts
  • Recent Posts
  • Recent Comments
Dynamics365Authority is a community platform for Professionals and Students to contribute or share their knowledge and skills on Microsoft Dynamics 365 Technologies. Our primary goal is to invite professionals on Dynamics 365 technology across the world to contribute & share their knowledge and skills through their blogs so that we can help other developers.
Stay updated with Dynamics 365 technology. Improve skills and knowledge from our blogs, articles and code snippets. Learn it. Follow professionals and learn from them.
Unified Service Desk Book(Online Edition) 

FOLLOW US

Stay connected with us on our social media channels for latest articles, blogs posts etc.  We will keep updating regularly on our social media platform and web platform.

FACEBOOK

Follow us on Facebook

 

TWITTER

View all our tweets

 

DYNAMICS365AUTH

Join us now

 

BLOGS

View our blogs

 

 

Latest Blog

Posted: Feb 18, 2019

Digital Transformation of Businesses using Dynamics CRM - Preface

This blog is about the Digital Transformation of Businesses using Dynamics CRM - Preface

Read more
Posted: Feb 17, 2019

Tips

This blog is about the Tips of Digital Transformation of Busineeses using Dynamics 365

Read more
Posted: Feb 17, 2019

Dynamic 365 with the Internet of Things (Iot) Driving Digital Transformation

This blog is about the Dynamic 365 with the Internet of Thing(IoT

Read more
RSS

ADDITIONAL RESOURCES

Dynamics 365 Authority.com - Search the library for "Dynamics 365"

  What's New in Dynamics 365

  Dynamics 365 Documentation

  

  Sign-up for 30 days trial

 

 

Recent comments

Ashish:

Nice blog. Very helpful to get all references to white papers at one place.

Previous Next

About Us

Here comes the Dynamics 365 Authority - Great technical blog posts are hidden gems. They are hard to find simply because not enough of us write them in the first place. Yet technical blogging is one of the best things we can do not only for ourselves, but also as members of the wider community of developers.

Dynamics 365 Authority leverages this platform to help developers and users to move from traditional paper-based process to modern digital business process. Dynamics365Authority.com helps your business grow, evolve and transform.

Dynamics365Authority.com is your Digital Transformation Partner

Recent Posts

Digital Transformation of Businesses using Dynamics CRM - Preface

This blog is about the Digital Transformation of Businesses using Dynamics CRM - Preface
  • 145
  • Article rating: 5.0

Tips

This blog is about the Tips of Digital Transformation of Busineeses using Dynamics 365
  • 10
  • Article rating: 5.0
RSS

Get in touch

Follow Us

 

Tag cloud: Dynamics365Authority.com with Urish Arora; Dynamics365Authority.com; Sales; Leading community site on MS Dynamics 365; Dynamics 365 Authority; Service;Top CRM Blogs; Urish Arora - Australia's leading expert on Digital Transformation;  Digital Transformation; Field Service;Top Articles on MS Dynamics CRM Relationship Insights; Office 365 Security Compliance; Project Service; Microsoft Dynamics 365 for Sales; Relevance Search; Goal Metrics; Activities and Case; Sales Literature;Knowledge Management;

Terms Of UsePrivacy StatementCopyright 2019 by Dynamics365Authority
Back To Top