Hello, I have a two server SharePoint 2007 server farm which includes one front end and one SQL 2008 R2 server. The web application is extended with two zones - 1) Windows based auth - Extranet 2) Forms based authentication - Internet. Browsing to the Internet zone, I get the FBA login page. i created a user using the ASP.Net Web site Administration tool on the SQL sever. But, I am not seeing this user in the SQL Forms authentication database from the Add Users from People and Groups page. Can someone help me in right steps to enable this. Thanks in advance, John

Hi John, You should provide the membership provider and connection string details in the web.config file of both your sitecollection as well as in central administrator. by default these users are stored in aspnetdb database. if this user is a local user you must add this user to your system else if the user is a domain user then user automatically comes to Add users page. you must give one of the user as a sitecollection administrator and he has to add the other users to the site. please check all above conditions . Thanks, Nivas

Hi JohnFL_B, Thank you for sharing your problem. For your problem, could you please check this article to see if there is any error in your FBA configuration process: http://technet.microsoft.com/en-us/library/cc262201(office.12).aspx. And please refer to these blogs, perhaps you can solve your problem through the ways there: http://blogs.msdn.com/b/jjameson/archive/2010/03/23/forms-based-authentication-in-moss-2007-the-easy-way.aspx; http://psterpe.wordpress.com/2009/05/24/adding-users-with-sharepoint-forms-based-authentication/. Hope this could help you. Regards