I am looking for assistance in configuring FBA for Sharepoint. I have configured the db using aspnet_regsql as well as defined the configuration at 3 web.config files (STS, web app and central admin). However, the following issues arise and I have followed at least a dozen different web sites on the topic but the problem persists. The two issues that I face are:
i) Once the user logs in with FBA, Access is denied. I know the cause for that. It is because there is no default association between FBA Roles and sharepoint groups. However, the 2nd point that I raise below is why i cant create this association
ii) The user names (Central Admin --> web App --> user policy tab --> zone ---> add users) does not list any users in the database. I can see the FormsAuth tab in the left frame (but the only group i see is FORMS AUTHENTICATION ALL USERS.) The search for user names is empty as well.
I have also configured the PeoplePickerWildcards element in central config All my passwords are hashed because they were created with ASP.NET WEB SITE CONFIGURATION TOOL. Earlier, I was creating usernames by executing SQL queries directly on the SQL SERVER EXPRESS using SQL SERVER MANAGEMENT STUDIO. However, then i switched to using the configuration tool thinking that may be the cause rests somewhere in an incorrectly stored password due to hashing requirements. However, even that switch did not resolve the issue.
Please help me out as this issue has taken the entire work day of today :)