Solved

fba authentication with SQL in sharepoint 2013

Posted on 2015-02-05
5
150 Views
Last Modified: 2015-04-14
Hello to all,

I have installed Sharepoint 2013 along with SQL Server 2012 in the same box. I have configured FBA following instructions from:
http://blogs.technet.com/b/ptsblog/archive/2013/09/20/configuring-sharepoint-2013-forms-based-authentication-with-sqlmembershipprovider.aspx
http://chrisbarba.com/2013/07/16/sharepoint-2013-forms-based-authentication-fba/

However, once I log into the site collection I created and go to Site Settings and click on FBA Role Management I get the following error:
A Membership Provider has not been configured correctly. Check the web.config setttings for this web application.

I have already provided the right access permissions to the database I created for the user running my web application; I have looked over the configuration for my 3 web.config files (SharePoint Central Administration, SecurityTokenServiceApplication and the SharePoint web application) and found no errors; and I have also googled the error and found no solution for my problem. Any help will be appreciated.
Thanks in advance.
0
Comment
Question by:essi1
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 15

Accepted Solution

by:
colly92002 earned 250 total points
ID: 40602951
Usually in these circumstances it comes down to permissions.

In this case, your service account needs access to aspnetdb, Check IIS to ensure that the service accounts that apppools are running under have access to this database.

Also check your ULS logs as they should contain a more specific error (hopefully it will say "login failed for xxxxx on yyyyy" and it will be obvious where the error lies).
0
 
LVL 19

Assisted Solution

by:Walter Curtis
Walter Curtis earned 250 total points
ID: 40609186
Do you have any more specific information. Check event viewer and on SQL server check security event log to see if there are specific issues. Also, have you checked all networking settings, firewall settings, anything that might cause an issue. The error is very generic and could be a total smokescreen from the real issue(s)

Thanks
0
 

Author Comment

by:essi1
ID: 40614057
Hello and thank you for both of your answers. I'm still working on this issue, but got some other priorities right now. I will follow your suggestions and will post back the results hopefully by the end of this week. I really appreciate your time and knowledge.
Thanks
0
 

Author Closing Comment

by:essi1
ID: 40722892
Hello colly92002 and SneekCo,
I want to thank you both again for you input. I agree with you colly92002, it sounds like a permissions issue, but I searched all over and couldn't find what I was missing. I created 2 more web applications from scratch and linked them to 2 different new databases and checked all the permissions, but could not get this working. However, I moved on as I thought about a different solution that satisfied my needs. I wanted to allow users external to my AD to login to my Sharepoint site, so I created a one-way trust with a test domain I have and created security groups in my domain. That way I can just add users to the test domain and then add them to the security group and assign the group the permissions I want them to have in my Sharepoint site. It's sort of a workaround, but works for me, so I'm sharing it... who knows if helps someone else.
Thanks again.
0
 
LVL 19

Expert Comment

by:Walter Curtis
ID: 40722972
Thanks and best of luck to you!
0

Featured Post

WordPress Tutorial 4: Recommended Plugins

Now that you have WordPress installed, understand the interface, and know how to install new parts, let’s take a look at our recommended plugins.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL several years ago, it seemed like now was a good time to update it for object-oriented PHP.  This article does that, replacing as much as possible the pr…
Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
Use Wufoo, an online form creation tool, to make powerful forms. Learn how to selectively show certain fields based on user input using rules to gather relevant information and data from your forms. The rules feature provides you with an opportunity…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question