i am trying to configure form based authentication in sharepoint. My server name is SPSERVER and when i create web application in sharepoint "SPSERVER\Microsoft##SSEE" appeared in database server field. i am following the method as in this link. http://www.simple-talk.com/dotnet/windows-forms/configuring-forms-authentication-in-sharepoint-2007/ when i run aspnet_sqlreg.exe, in the server name field i wrote SPSERVER instead of SPSERVER\Microsoft##SSEE because the SPSERVER\Microsoft##SSEE generated an error "--------------------------- Connection failed --------------------------- An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)" so i create database in SPSERVER. then i done the changes in web.config file as described in the method. and when i open the ASP.Net configuration in visual studio 2008 when i click on security i recieve the following error "There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store. The following message may help in diagnosing the problem: Unable to connect to SQL Server database. " Can some one tell me what is the problem?

hi, Could you check Fba db connecting string i think there might be the issues.such as 1. Connecting string is wrong. 2.DB server is not reachable from sharepoint server. 3. Can you Sharepoint logs what are the error for the same which is in 12 hive folder. 4. Whats the issue with creating FBA db with regsql command can you explain it in details. So after that have you create instance of sql? so check these thing .If still there is an issue let me know.Thanks Shrivallabh Kulkarni

Hi I leave that method and apply the following method Form Authentication in sharepoint all is fine but when i enter the username and password, it does not redirect me to the site, it remains on same page and does not give an error or any message. if someone know about this method and know the solution then please tell me the solution. Thanks

There is a video tutorial for this: http://channel9.msdn.com/shows/In+the+Office/Anonymous-Access-and-Forms-Authentication-with-WSS-30/ See if it helps for you.Sincerely, Lambert Qin Posting is provided "AS IS" with no warranties, and confers no rights.