Subscribe:      
 

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

Update SharePoint Central Admin web.config

Please note updating the web.config incorrectly can damage your SharePoint installation. Extreme care should be taken, please do not edit the web.config if you are not familiar with web.config or XML structures.

  1. Locate your web.config file for the SharePoint Central Administration website. Normally located in C:\Inetpub\wwwroot\wss\VirtualDirectories
  2. Take special care to select the right Virtual Directory, mine is named SharePointCA80 yours will be different
  3. Locate the web.config file, make a backup of it, and then open it with notepad
  4. Scroll down to the configuration node, <configuration> find <connectionStrings>


  5. <connectionStrings>
    <add name="ADConnectionString" 
    connectionString="Data Source=<server name>; Initial Catalog=<database name>; Integrated Security=True" /> </connectionStrings>

  6. As before replace both <server name> and <database name> with their appropriate values.
  7. Scroll down to the system web <system.web> node and the following membership provider, as before


  8. <!-- membership provider -->
    <membership defaultProvider="FBADemoMember">
    <providers>
    <add
    connectionStringName="AspNetDbFBADemoConnectionString"
    enablePasswordRetrieval="false"
    enablePasswordReset="true"
    requiresQuestionAndAnswer="false"
    applicationName="/"
    requiresUniqueEmail="false"
    passwordFormat="Hashed"
    maxInvalidPasswordAttempts="5"
    minRequiredPasswordLength="1"
    minRequiredNonalphanumericCharacters="0"
    passwordAttemptWindow="10"
    passwordStrengthRegularExpression=""
    name="FBADemoMember"
    type="System.Web.Security.SqlMembershipProvider, System.Web,Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
    </providers>
    </membership>

    <!-- role provider -->
    <roleManager enabled="true" defaultProvider="FBADemoRole">
    <providers>
    <add
    connectionStringName="AspNetDbFBADemoConnectionString"
    applicationName="/"
    name="FBADemoRole"
    type="System.Web.Security.SqlRoleProvider, System.Web,Version=2.0.0.0,Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>
    </providers>
    </roleManager>

  9. Save and close the web.config for SharePoint Central Administration
  10. Update the web.config of SharePoint Web application
  11. Repeat steps 1 to 7 for the web.config of the SharePoint web application you configured the Authentication Provider for Forms Based Authentication above, i.e. the Extranet site
  12. Check the authentication in this web.config is set to the following.


  13. <authentication mode="Forms">
    <forms loginUrl="/_layouts/login.aspx"></forms>
    </authentication>
    

Note you can specify a custom login page here, shown as loginUrl="" above.

< 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.


MSSharePointTips.com | MSSQLTips.com