I'm trying to figure out why my FBA keeps breaking down on me. It has happened on two servers now. I've gotten FBA up and running, added users, etc. Then after a day or two users begin to not be able to log in. The aspnetdb seems to be fine, the users are not showing signs of being locked out. If I try to log in, I get a '..check your user name and password.." type error shown on the fba login screen. The first time in a group of login attempts seems to throw an error to the event log, but after that, subsequent attempts do not log an error. I have seen both 4005 and 4006 errors in the log on these occasions.
I've checked my web.config, the timeouts seem fine and the application names are all set to "/".
I've tried deleting the aspnetdb and recreating it, though after the recreation, Central Administration can no longer find any users to add them to the web application administrators group. Therefor I can't update the site settings or give anyone access to the site.
I'm not sure if this has anything to do with using SPCommands for Powershell to set up the FBA. Please let me know if anyone has experienced similar issues using this setup package. I'm using it because in the production environment we will not be able to install visual studio to get the aspnetdb initial user created. Are there any other ways of getting the db setup without VS