{"id":325,"date":"2016-05-19T01:07:09","date_gmt":"2016-05-19T05:07:09","guid":{"rendered":"http:\/\/blogs.visigo.com\/chriscoulson\/?p=325"},"modified":"2018-12-24T09:46:12","modified_gmt":"2018-12-24T14:46:12","slug":"configuring-forms-based-authentication-in-sharepoint-2016-sharepoint-2019-part-4-adding-users-to-the-membership-database","status":"publish","type":"post","link":"https:\/\/blogs.visigo.com\/chriscoulson\/configuring-forms-based-authentication-in-sharepoint-2016-sharepoint-2019-part-4-adding-users-to-the-membership-database\/","title":{"rendered":"Configuring Forms Based Authentication in SharePoint 2016 and SharePoint 2019 &#8211; Part 4 &#8211; Adding Users to the Membership Database"},"content":{"rendered":"<p>Configuring forms based authentication (FBA) in SharePoint 2016 and SharePoint 2019 is exactly the same process as configuring it for SharePoint 2013. \u00a0I&#8217;ve recreated the <a href=\"https:\/\/blogs.visigo.com\/chriscoulson\/configuring-forms-based-authentication-in-sharepoint-2013-part-1-creating-the-membership-database\/\">SharePoint 2013 FBA\u00a0tutorial<\/a> specifically for SharePoint 2016 and SharePoint 2019, using screenshots from SharePoint 2016 and Windows Server 2012 R2. \u00a0I have changed the tutorial to use the <a href=\"https:\/\/www.visigo.com\/products\/sharepoint-fba-pack\/\">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.<\/p>\n<p>I\u2019ll go through all of the steps required to setup FBA for SharePoint 2016 and 2019, 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\u00a0<a title=\"Configuring Forms Based Authentication in SharePoint 2013 \u2013 Part 3 \u2013 Editing the Web.Config Files\" href=\"https:\/\/blogs.visigo.com\/chriscoulson\/configuring-forms-based-authentication-in-sharepoint-2016-sharepoint-2019-part-2-editing-the-web-config-files\/\">Part 2<\/a>.<\/p>\n<p><a href=\"https:\/\/blogs.visigo.com\/chriscoulson\/configuring-forms-based-authentication-in-sharepoint-2016-sharepoint-2019-part-1-creating-the-membership-database\/\">Part 1 &#8211; Creating the Membership Database<\/a><\/p>\n<p><a href=\"https:\/\/blogs.visigo.com\/chriscoulson\/configuring-forms-based-authentication-in-sharepoint-2016-sharepoint-2019-part-2-editing-the-web-config-files\/\">Part 2 &#8211; Editing the Web.Config Files<\/a><\/p>\n<p><a href=\"https:\/\/blogs.visigo.com\/chriscoulson\/configuring-forms-based-authentication-in-sharepoint-2016-sharepoint-2019-part-3-configuring-sharepoint\/\">Part 3 &#8211; \u00a0Configuring SharePoint<\/a><\/p>\n<p><a href=\"https:\/\/blogs.visigo.com\/chriscoulson\/configuring-forms-based-authentication-in-sharepoint-2016-sharepoint-2019-part-4-adding-users-to-the-membership-database\/\">Part 4 &#8211; Adding Users to the Membership Database<\/a><\/p>\n<p>You can also watch a video of the whole process on YouTube: <a href=\"https:\/\/youtu.be\/a-oTHcWAEmA\">Configuring Forms Based Authentication in SharePoint 2016 and SharePoint 2019<\/a>.<\/p>\n<h2>Part 4\u00a0&#8211; Adding Users to the Membership Database<\/h2>\n<p>At this point SharePoint has been completely been setup for forms based authentication. Unfortunately people still can&#8217;t login with FBA, as no users have been added to the membership database.<\/p>\n<p>There are a few ways to add users to the membership database. \u00a0You can manage the users in the membership database using IIS. I prefer to manage the users in SharePoint using the <a href=\"https:\/\/www.visigo.com\/products\/sharepoint-fba-pack\/\">SharePoint FBA Pack<\/a>. I&#8217;m going to show you how to install the FBA Pack and use it to add users to your membership database.<\/p>\n<ul>\n<li>You can find downloads and documentation for the SharePoint 2016 FBA Pack at\u00a0<a href=\"https:\/\/www.visigo.com\/products\/sharepoint-fba-pack\">https:\/\/www.visigo.com\/products\/sharepoint-fba-pack<\/a><a href=\"https:\/\/blogs.visigo.com\/chriscoulson\/wp-content\/uploads\/2016\/05\/sharepoint2016fba_addusers_fbapack.png\" rel=\"attachment wp-att-328\">.<\/a><\/li>\n<li>Download the FBA Pack and unzip it to a folder on your hard drive. For this example I&#8217;ve unzipped to c:\\deploy.<a href=\"https:\/\/blogs.visigo.com\/chriscoulson\/wp-content\/uploads\/2016\/05\/sharepoint2016fba_addusers_2_deploy_folder.png\" rel=\"attachment wp-att-329\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-329\" src=\"https:\/\/blogs.visigo.com\/chriscoulson\/wp-content\/uploads\/2016\/05\/sharepoint2016fba_addusers_2_deploy_folder-500x320.png\" alt=\"deploy folder\" width=\"500\" height=\"320\" srcset=\"https:\/\/blogs.visigo.com\/chriscoulson\/wp-content\/uploads\/2016\/05\/sharepoint2016fba_addusers_2_deploy_folder-500x320.png 500w, https:\/\/blogs.visigo.com\/chriscoulson\/wp-content\/uploads\/2016\/05\/sharepoint2016fba_addusers_2_deploy_folder-300x192.png 300w, https:\/\/blogs.visigo.com\/chriscoulson\/wp-content\/uploads\/2016\/05\/sharepoint2016fba_addusers_2_deploy_folder-768x492.png 768w, https:\/\/blogs.visigo.com\/chriscoulson\/wp-content\/uploads\/2016\/05\/sharepoint2016fba_addusers_2_deploy_folder.png 933w\" sizes=\"auto, (max-width: 500px) 100vw, 500px\" \/><\/a><\/li>\n<li>Open either PowerShell (In Administrator mode) or SharePoint Management Shell.<\/li>\n<li>Navigate to the c:\\deploy folder: &#8220;cd c:\\deploy&#8221;<a href=\"https:\/\/blogs.visigo.com\/chriscoulson\/wp-content\/uploads\/2016\/05\/sharepoint2016fba_addusers_3_powershell.png\" rel=\"attachment wp-att-330\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-330\" src=\"https:\/\/blogs.visigo.com\/chriscoulson\/wp-content\/uploads\/2016\/05\/sharepoint2016fba_addusers_3_powershell-500x251.png\" alt=\"Powershell\" width=\"500\" height=\"251\" srcset=\"https:\/\/blogs.visigo.com\/chriscoulson\/wp-content\/uploads\/2016\/05\/sharepoint2016fba_addusers_3_powershell-500x251.png 500w, https:\/\/blogs.visigo.com\/chriscoulson\/wp-content\/uploads\/2016\/05\/sharepoint2016fba_addusers_3_powershell-300x150.png 300w, https:\/\/blogs.visigo.com\/chriscoulson\/wp-content\/uploads\/2016\/05\/sharepoint2016fba_addusers_3_powershell.png 676w\" sizes=\"auto, (max-width: 500px) 100vw, 500px\" \/><\/a><\/li>\n<li>Run &#8220;.\\deploy http:\\\\win-h472cerv00l&#8221; (without quotes and be sure to substitute the url to your site collection where you would like the FBA Pack activated). \u00a0Note you can also run &#8220;.\\deploy&#8221; without any parameters &#8211; in which case you will have to manually activate the &#8220;Forms Based Authentication Management&#8221; feature in each site collection you&#8217;d like to use it.<a href=\"https:\/\/blogs.visigo.com\/chriscoulson\/wp-content\/uploads\/2016\/05\/sharepoint2016fba_addusers_4_deploy_fba_pack.png\" rel=\"attachment wp-att-331\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-331\" src=\"https:\/\/blogs.visigo.com\/chriscoulson\/wp-content\/uploads\/2016\/05\/sharepoint2016fba_addusers_4_deploy_fba_pack-500x251.png\" alt=\"Deploy FBA Pack\" width=\"500\" height=\"251\" srcset=\"https:\/\/blogs.visigo.com\/chriscoulson\/wp-content\/uploads\/2016\/05\/sharepoint2016fba_addusers_4_deploy_fba_pack-500x251.png 500w, https:\/\/blogs.visigo.com\/chriscoulson\/wp-content\/uploads\/2016\/05\/sharepoint2016fba_addusers_4_deploy_fba_pack-300x151.png 300w, https:\/\/blogs.visigo.com\/chriscoulson\/wp-content\/uploads\/2016\/05\/sharepoint2016fba_addusers_4_deploy_fba_pack.png 674w\" sizes=\"auto, (max-width: 500px) 100vw, 500px\" \/><\/a><\/li>\n<li>The script will deploy the FBA Pack to the SharePoint farm and activate it on your site collection. Note that if you get an error and scripts won&#8217;t run because they are not signed, you need to run the following command to allow the script to run: &#8220;Set-ExecutionPolicy Unrestricted&#8221;. Once you&#8217;ve done that, rerun the deploy script.<\/li>\n<li>Navigate to your site collection and login as a site collection administrator. Navigate to the Site Settings page. You will notice you now have some new options for managing FBA Users.<a href=\"https:\/\/blogs.visigo.com\/chriscoulson\/wp-content\/uploads\/2016\/05\/sharepoint2016fba_addusers_5_sharepoint_site_Settings.png\" rel=\"attachment wp-att-338\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-338\" src=\"https:\/\/blogs.visigo.com\/chriscoulson\/wp-content\/uploads\/2016\/05\/sharepoint2016fba_addusers_5_sharepoint_site_Settings-500x267.png\" alt=\"SharePoint 2016 Site Settings\" width=\"500\" height=\"267\" srcset=\"https:\/\/blogs.visigo.com\/chriscoulson\/wp-content\/uploads\/2016\/05\/sharepoint2016fba_addusers_5_sharepoint_site_Settings-500x267.png 500w, https:\/\/blogs.visigo.com\/chriscoulson\/wp-content\/uploads\/2016\/05\/sharepoint2016fba_addusers_5_sharepoint_site_Settings-300x160.png 300w, https:\/\/blogs.visigo.com\/chriscoulson\/wp-content\/uploads\/2016\/05\/sharepoint2016fba_addusers_5_sharepoint_site_Settings-768x410.png 768w, https:\/\/blogs.visigo.com\/chriscoulson\/wp-content\/uploads\/2016\/05\/sharepoint2016fba_addusers_5_sharepoint_site_Settings.png 1497w\" sizes=\"auto, (max-width: 500px) 100vw, 500px\" \/><\/a><\/li>\n<li>Select &#8220;FBA User Management&#8221;.<a href=\"https:\/\/blogs.visigo.com\/chriscoulson\/wp-content\/uploads\/2016\/05\/sharepoint2016fba_addusers_6_manage_users.png\" rel=\"attachment wp-att-339\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-339\" src=\"https:\/\/blogs.visigo.com\/chriscoulson\/wp-content\/uploads\/2016\/05\/sharepoint2016fba_addusers_6_manage_users-500x268.png\" alt=\"SharePoint 2016 FBA Pack Manage Users\" width=\"500\" height=\"268\" srcset=\"https:\/\/blogs.visigo.com\/chriscoulson\/wp-content\/uploads\/2016\/05\/sharepoint2016fba_addusers_6_manage_users-500x268.png 500w, https:\/\/blogs.visigo.com\/chriscoulson\/wp-content\/uploads\/2016\/05\/sharepoint2016fba_addusers_6_manage_users-300x161.png 300w, https:\/\/blogs.visigo.com\/chriscoulson\/wp-content\/uploads\/2016\/05\/sharepoint2016fba_addusers_6_manage_users-768x412.png 768w, https:\/\/blogs.visigo.com\/chriscoulson\/wp-content\/uploads\/2016\/05\/sharepoint2016fba_addusers_6_manage_users.png 1496w\" sizes=\"auto, (max-width: 500px) 100vw, 500px\" \/><\/a><\/li>\n<li>Click &#8220;New User&#8221;.<a href=\"https:\/\/blogs.visigo.com\/chriscoulson\/wp-content\/uploads\/2016\/05\/sharepoint2016fba_addusers_7_new_user.png\" rel=\"attachment wp-att-340\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-340\" src=\"https:\/\/blogs.visigo.com\/chriscoulson\/wp-content\/uploads\/2016\/05\/sharepoint2016fba_addusers_7_new_user-500x267.png\" alt=\"SharePoint 2016 FBA Pack New User\" width=\"500\" height=\"267\" srcset=\"https:\/\/blogs.visigo.com\/chriscoulson\/wp-content\/uploads\/2016\/05\/sharepoint2016fba_addusers_7_new_user-500x267.png 500w, https:\/\/blogs.visigo.com\/chriscoulson\/wp-content\/uploads\/2016\/05\/sharepoint2016fba_addusers_7_new_user-300x160.png 300w, https:\/\/blogs.visigo.com\/chriscoulson\/wp-content\/uploads\/2016\/05\/sharepoint2016fba_addusers_7_new_user-768x410.png 768w, https:\/\/blogs.visigo.com\/chriscoulson\/wp-content\/uploads\/2016\/05\/sharepoint2016fba_addusers_7_new_user.png 1494w\" sizes=\"auto, (max-width: 500px) 100vw, 500px\" \/><\/a><\/li>\n<li>Fill out the form to create your first user in the FBA database. Be sure to assign them to a SharePoint group so that they will have permissions to login to SharePoint.<\/li>\n<li>Now you can try to login as the user you just created. Logout of SharePoint. When logging back into SharePoint, choose to login using Forms Based Authentication. Login using the username and password you created on the FBA User Management screen.<a href=\"https:\/\/blogs.visigo.com\/chriscoulson\/wp-content\/uploads\/2016\/05\/sharepoint2016fba_addusers_8_login.png\" rel=\"attachment wp-att-336\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-336\" src=\"https:\/\/blogs.visigo.com\/chriscoulson\/wp-content\/uploads\/2016\/05\/sharepoint2016fba_addusers_8_login-500x267.png\" alt=\"SharePoint 2016 FBA Login\" width=\"500\" height=\"267\" srcset=\"https:\/\/blogs.visigo.com\/chriscoulson\/wp-content\/uploads\/2016\/05\/sharepoint2016fba_addusers_8_login-500x267.png 500w, https:\/\/blogs.visigo.com\/chriscoulson\/wp-content\/uploads\/2016\/05\/sharepoint2016fba_addusers_8_login-300x160.png 300w, https:\/\/blogs.visigo.com\/chriscoulson\/wp-content\/uploads\/2016\/05\/sharepoint2016fba_addusers_8_login-768x410.png 768w, https:\/\/blogs.visigo.com\/chriscoulson\/wp-content\/uploads\/2016\/05\/sharepoint2016fba_addusers_8_login.png 1498w\" sizes=\"auto, (max-width: 500px) 100vw, 500px\" \/><\/a><\/li>\n<\/ul>\n<p>That&#8217;s it! \u00a0You now have Forms Based Authentication setup on SharePoint 2016, and the <a href=\"https:\/\/www.visigo.com\/products\/sharepoint-fba-pack\/\">FBA Pack<\/a> installed to manage your FBA users. \u00a0Be sure to check out the rest of the features of the <a href=\"https:\/\/www.visigo.com\/products\/sharepoint-fba-pack\/\">SharePoint FBA Pack<\/a> &#8211; on top of allowing you to manage users and roles, it also includes web parts for user registration, changing your password and recovering a forgotten password.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Configuring forms based authentication (FBA) in SharePoint 2016 and SharePoint 2019 is exactly the same process as configuring it for SharePoint 2013. \u00a0I&#8217;ve recreated the SharePoint 2013 FBA\u00a0tutorial specifically for SharePoint 2016 and SharePoint 2019, using screenshots from SharePoint 2016 and Windows Server 2012 R2. \u00a0I have changed the tutorial to use the SharePoint FBA [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[129,19,5],"tags":[321,94,296,130,20,298,316,159,294,21,297,325,326,328,329,330,295,293],"class_list":["post-325","post","type-post","status-publish","format-standard","hentry","category-configuration","category-forms-based-authentication","category-sharepoint","tag-net","tag-asp-net","tag-aspnetdb","tag-central-admin","tag-fba","tag-fba-pack","tag-forms-based-authentication","tag-iis","tag-machine-config","tag-membership","tag-membership-provider","tag-sharepoint-2016","tag-sharepoint-2016-fba-pack","tag-sharepoint-2019","tag-sharepoint-2019-fba-pack","tag-sharepoint-fba-pack","tag-sqlmembershipprovider","tag-web-config"],"_links":{"self":[{"href":"https:\/\/blogs.visigo.com\/chriscoulson\/wp-json\/wp\/v2\/posts\/325","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.visigo.com\/chriscoulson\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.visigo.com\/chriscoulson\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.visigo.com\/chriscoulson\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.visigo.com\/chriscoulson\/wp-json\/wp\/v2\/comments?post=325"}],"version-history":[{"count":17,"href":"https:\/\/blogs.visigo.com\/chriscoulson\/wp-json\/wp\/v2\/posts\/325\/revisions"}],"predecessor-version":[{"id":433,"href":"https:\/\/blogs.visigo.com\/chriscoulson\/wp-json\/wp\/v2\/posts\/325\/revisions\/433"}],"wp:attachment":[{"href":"https:\/\/blogs.visigo.com\/chriscoulson\/wp-json\/wp\/v2\/media?parent=325"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.visigo.com\/chriscoulson\/wp-json\/wp\/v2\/categories?post=325"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.visigo.com\/chriscoulson\/wp-json\/wp\/v2\/tags?post=325"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}