Skip to main content

Claims Walkthrough: Creating Forms-Based Authentication (FBA) for Claims-Based SharePoint 2010 Web Applications Using ASP.NET SQL Membership and Role Providers

Dear All 

In last Post I got the solution to make the FBA with AD in this post the we are create FBA authentication with SQL database

This is post in which i found the correct solution of FBA with SQL Server 

Step 1: Create a Web application with Form Based Authentication 


Step 2: Create the SQL database and allow User Persmission


Step 3: Update Web.config for Web Application, Central Administration & Security Token Service File Via Tool 



Download the Tool from following URL:


Note: Make sure you need follow the instruction as per download file Read Me. txt 


Step 4: Create User Under SQL and Define the Permission Group 

I use the following command In SQL server instead of running the define PS Script 


declare @now datetime
set @now= GETDATE()
exec aspnet_Membership_CreateUser '/','User Name','password',
    '','email@yourdomian.com','','',1,@now,@now,0,0,null
Note: Replace User name with the user name that you required and password with the required password while email@yourdomain.com will be the define user email address if present 

Do the following Step to allow the access to defined user name: 

  1. Login with the main windows account 
  2. Go to Site Settings > Site Permission > Your Site Name Owners > New
  3. Type the user name and Click ok
That's it and now log out and login again with the FBA user. 


But if you want alternative step 4 below is showing 

As per video 
Below is an alternative method but it little bit dependent
  

Hope it save your time it spend my 2 days to get the correct FBA configuration 

Regards
3art Technology Experts
http://www.3art.tech


Labels:

Comments

Post a Comment

Popular posts from this blog

Updatepanel or Enable Ajax in SharePoint webpart

Dear All It is really giving me a hard to get this techniques if you want to run the update panel in sharepoint 2013 webpart then you need to initialize the script manage by code   protected override void OnInit(EventArgs e)         {             base.OnInit(e);             InitializeControl();             // Register the ScriptManager             ScriptManager scriptManager = ScriptManager.GetCurrent(this.Page);             if (scriptManager == null)             {                 scriptManager = new ScriptManager();                 scriptManager.ID = "ScriptManager1";                 scriptManager.EnablePartialRendering = true;       ...
23 comments
Read more

[Solved] SharePoint 2013 And Adobe Reader Problem : The URL you have provided could not be reached. Please verify that the URL is correct and that the network location is reachable

Dear All  When trying to open a PDF file from a mapped drive in SharePoint 2010.  You might see the following error message. The URL you have provided could not be reached. Please verify that the URL is correct and that the network location is reachable. 1. Open the registry. 2. Go to HKLM Local Software\SOFTWARE\Policies\Adobe\\\FeatureLockDown. 3. Create a key called cSharePoint. 4. Create a DWORD value called bDisableSharePointFeatures. 5. Set its value to 1. Regards Rashid Imran Bilgrami CEO Best visualization http://www.bestvisualization.com  
Post a Comment
Read more

SharePoint calculated column and hyperlink or Link (no workflows or scripts needed)

This is a process how you make the Link column in your sharepoint link original url Create a calculated column which concatenate the url text with an existing column value. This seems to be an easy task, except one thing: SharePoint doest not render hyperlink in calculated column by default. For example, I have a list with 2 columns: Search term and Google Search. Google Search is a calculated column with this formula Now, this is what I will get by default: There are a few ways to fix this problem. Usually people will recommend you to create a Hyperlink column instead and create a workflow to update the Hyperlink value ( http://social.technet.microsoft.com/Forums/ar/sharepoint2010customization/thread/32d32e47-3256-4806-8775-c250b6243038 ) . Or, you can place a script on the page that loop through the HTML nodes and replace the unfriendly html tags with a hyperlink as described here http://practicalsharepoint.blogspot.com/2011/10/dynamic-hyperlinks-in-calculated.html ...
7 comments
Read more