Hi, I have configured the FBA on my stand alone development server with the help of this MSDN article (http://msdn.microsoft.com/en-us/library/bb975136.aspx). I'm using SQL DB to store the user authentication information. After I have configured the user and access the extranet site(http://sharepoint.extranet.org), it redirects to login page but when I enters user name and password it does not redirect anywhere. Also it does not show any error message on the login form or in the windows event viewer. What could be the problem? Thanks in advance, Sanban

When you say 'it does not redirect anywhere', then what does it do after you've provided credentials? Does it display a blank page, display an error page - please describe the exact behavior. Did you create a site collection via the Central Admin page underneathe the web application that uses FBA?

maybe u did not correctly mentioned the reference to your DB when u set up your FBA, can u be more precise what actually happens their must be some error msg ?

Hi Tracy, Thanks for replying.. No it does not display blank or error page, it just stays there in _layouts/login.aspx page. I get this behaviour for both valid or invalid credentials. Also I do not see any error log in both 12 Hive log or event viewer, so not sure whats wrong with this. I followed exactly the same steps thats mentioned in this article. Any clue?

As I mentioned before there is no error message gets logged any where. I use the same connection string format as mentioned in the article to conect to DB: <add name="fbaSQL" connectionString="server=myservernamehere;database=aspnetdb;Trusted_Connection=true" />

Hi Sanban, Sometimes when this happened to me I just shut down the server and turn on again and the problem disappeared. Regards, Silvina A. Pizzarulli. http://www.silvinapizzarulli.blogspot.com

Oh really ..I have not tried this though ..will update if this resolve this issue. Thanks ..

Hi Silvina, After I restarted the server, I started getting the error message. On the login page I'm getting "Unknown Error" and in 12 hive log the error mssage says: Exception Type: System.Data.SqlClient.SqlException Exception Message: EXECUTE permission denied on object 'aspnet_CheckSchemaVersion', database 'aspnetdb', schema 'dbo'. Whats the issue here?

Hi Sanban, You should check if the application pool user of your web application, has execute permissions in aspnetdb. And if you want to see the proper error page, edit the web.config and change this: callstack="true" and customErrors mode="Off" Regards,Silvina A. Pizzarulli. http://www.silvinapizzarulli.blogspot.com

Thanks Silvina, yes giving execute permission to application pool account for that database worked. But as per the Microsoft article it says we just need to give READ permission not EXECUTE.. Anyway Thanks a lot again, Sanban