{"id":297,"date":"2016-05-19T01:05:19","date_gmt":"2016-05-19T05:05:19","guid":{"rendered":"http:\/\/blogs.visigo.com\/chriscoulson\/?p=297"},"modified":"2022-07-19T15:06:09","modified_gmt":"2022-07-19T19:06:09","slug":"configuring-forms-based-authentication-in-sharepoint-2016-sharepoint-2019-part-1-creating-the-membership-database","status":"publish","type":"post","link":"https:\/\/blogs.visigo.com\/chriscoulson\/configuring-forms-based-authentication-in-sharepoint-2016-sharepoint-2019-part-1-creating-the-membership-database\/","title":{"rendered":"Configuring Forms Based Authentication in SharePoint 2016, SharePoint 2019 and SharePoint Subscription Edition \u2013 Part 1 \u2013 Creating the Membership Database"},"content":{"rendered":"

Configuring forms based authentication (FBA) in SharePoint 2016, SharePoint 2019 and SharePoint Subscription Edition is exactly the same process as configuring it for SharePoint 2013. \u00a0I’ve recreated the SharePoint 2013 FBA\u00a0tutorial<\/a> specifically for SharePoint 2016, SharePoint 2019 and SharePoint Subscription Edition, using screenshots from SharePoint 2016 and Windows Server 2012 R2. \u00a0I have changed the tutorial to use the SharePoint FBA Pack<\/a> to create the FBA users, but otherwise it remains the same and can be used interchangeably between SharePoint 2013 and SharePoint 2016\/2019\/Subscription Edition.<\/p>\n

I\u2019ll go through all of the steps required to setup FBA for SharePoint 2016, 2019 and Subscription Edition, from start to finish. \u00a0I\u2019ve broken down the steps into 4 sections, so if you already have an existing membership database setup from a previous version of SharePoint, feel free to skip forward to\u00a0Part 2<\/a>.<\/p>\n

Part 1 – Creating the Membership Database<\/a><\/p>\n

Part 2 – Editing the Web.Config Files<\/a><\/p>\n

Part 3 – \u00a0Configuring SharePoint<\/a><\/p>\n

Part 4 – Adding Users to the Membership Database<\/a><\/p>\n

You can also watch a video of the whole process on YouTube: Configuring Forms Based Authentication in SharePoint 2016 and SharePoint 2019<\/a>.<\/p>\n

Part 1 \u2013 Creating the Membership Database<\/h2>\n

The first thing you need when configuring FBA for SharePoint is a place to keep all of the usernames and passwords. ASP.Net comes with a tool that we\u2019ll use to create a membership database to store the logon information.<\/p>\n