SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I want to implement forms based authentication for a sharepoint portal. I have used the standard ASP.NET membership provider database for test purpose and it work fine.

My client has Authentication details on their own SQL Database and I want to implement FBA that uses the custom database to authenticate users.

Does any one have any suggestions on how to implement this. Do I need to write a custom authentication provider?

share|improve this question
up vote 1 down vote accepted

If the schema of custom DB is same as aspnetDB, You can use the same provider with relevant connectionString in the central admin and the web application config.You can provide userid\pwd in the connectionString as below:

  <add name="MySqlConnection" connectionString="Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI;User ID=myDomain\myUsername; Password=myPassword;" />
  <membership defaultProvider="SqlProvider" userIsOnlineTimeWindow="15">
      <clear />
        passwordFormat="Hashed" />
share|improve this answer
Hi Amit, the schema is different – Kannan Feb 24 '12 at 5:18
Then you have to build a custom provider. This may be helpful : – Amit Kumawat Feb 24 '12 at 14:22

Have a look at SharePoint 2010 FBA Pack:

A forms based authentication pack for SharePoint 2010. It includes web parts for registering users, changing passwords and password recovery. It includes tools for managing users and roles and for approving registrations.

share|improve this answer
Hi Ashish, Does this work with custom database? – Kannan Feb 26 '12 at 23:41
Yes, check the documentation - and follow the first link. – Ashish Patel Feb 26 '12 at 23:45

I suggest you create you own MembershipProvider implementation since you are not going to use the default FBA database, but a custom database instead. It is not such a difficult to implement your own. check out these link

share|improve this answer
Creating custom membership is tricky. On the paper seems easy, but you really need to know what you do. But that's the way you should follow. – trip Feb 24 '12 at 13:00

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.