Configuring Forms Based Authentication For SharePoint 2010

Shiva Prasad B C

Technical Executive

Hi All,

Everyone is wondering why SharePoint 2010 Forms Based Authentication is a head ache. Guess what, its no longer is...!

The Security of SharePoint sites in 2010 are increased than ever before....!!!

The 8 Simple Steps for Configuring SharePoint 2010 FBA site

1. Creating Database (aspnetdb) :

a) Note : “Choose any Database name. In this example we are using aspnetdb”

Go to Start > Run > paste the below address in the address bar

C:\Windows\Microsoft.NET\Framework\v2.0.50727\aspnet_regsql.exe

Click OK to launch.

b) Choose ‘Configure SQL Server for Application Services’ and click Next.

c) Click Next and enter the name of the SQL Server, in this case the server name will be FBAServer.

d) Confirm that we have our Database (aspnetdb) created in SQL Management Studio on the SQL server.

2. Create Users in IIS 7.X

Using IIS to Populate Data for Database (aspnetdb) We Created in Step Before.

Open IIS Manger on Server
Select Default Web Site and Make Sure you are in Features View
Open Connection Strings Option under ASP.NET Section.
Click on LocalSqlServer Connection Sting & Provide SQL Server Name where you created aspnetdb in Earlier Step also Provide name of Database Created. Click ok
Once again Select Default Web Site & from Features View Click on .NET Users
Click on Add and Create New user in aspnetdb Click Finish
Create more users by repeating “steps f and g”.

3. Login to the SharePoint server.

Create a Claims Based Authentication Mode web application from Central Administration and assign a port number, application pool, and database name. The settings around Claims are below.

4. Open up IIS (inetmgr).

Select the SharePoint web application that you created and right-click. Click Explore and open the web.config in Notepad.
Find the line <system.web> in the web.config. Add the code below between the </SharePoint> and <system.web> tags.

Note : “Make sure that the Data Source name is changed.”

</connectionStrings>

c. Find the <add name=“i” tag, and then add the code below on the next line. (That is, add the code after the full <add name=“i” … /> statement.)

d. Find the <add name=“c” tag, and then add the code below on the next line (that is, add the code after the full <add name=“c” … /> statement).

5. In IIS Manager, right-click Central Administration v4 and click Explore. Open the web.config in Notepad.

Find the line <system.web> in the web.config. Add the code below between the </SharePoint> and <system.web> tags.

</connectionStrings>

Find the <roleManager and <membership tags in the web.config.

</providers>

</roleManager>

</providers>

</membership>

Replace the above with:

</providers>

</roleManager>

</providers>

</membership>

6. In IIS Manager, expand the SharePoint Web Services entry and right-click the SecurityTokenServiceApplication. Click Explore. Open the web.config in Notepad.