Configure SharePoint Forms Based Authentication to use SQL user accounts

Written By: Matt Takhar -- 8/11/2010 -- join -- contribute -- (3342) comments -- printer friendly version

Rating: Rate --

Categories: Configurations, IIS, Infrastructure, MOSS 2007, System Administration, WSS3

< Prev - 1 | 2 | 3 | 4 | 5 | - Next > | Become a paid author

Add an FBA user as a Site Collection Administrator

Now we need to make sure an FBA user can administer the site.

  1. Open Central Administration.
  2. Click on the Application Management tab.
  3. Click on Site collection administrators in the SharePoint Site Management section.
  4. Make sure your extranet is selected in the Site Collection drop down.
  5. Type spadmin into the Secondary Site Collection Administrator text box, then click the person icon to resolve the user.
  6. Click OK.

Note: This is one of the reasons why we needed update the SharePoint Central Administration web.config file.

Test the Extranet

Simply browse to your extranet URL and test you can authenticate using your SQL user account spadmin.

Common issues

  • DNS is not configured to resolve the Extranet address, try a simply ping from the commend line.
  • Invalid connection strings in the web.config files.
  • FBA users is not granted access to the Extranet site

Next Steps

< Prev - 1 | 2 | 3 | 4 | 5 | - Next >

Learn more about SharePoint

Sponsor Information

Copyright (c) 2010-2017 Edgewood Solutions, LLC All rights reserved
privacy | disclaimer | copyright | advertise | contribute | feedback | about
Some names and products listed are the registered trademarks of their respective owners. |