Forms Authentication Project Server 2007

[Juan Carlos]

We are developing and ASP .net application that uses the Project Server
Interface (PSI) webservices. First of all, it uses a Windows authentication
with the LoginWindows webservice. But if we use the LoginForms webservice
(with a Login page) it doesn´t work and display the next error message: “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 connection.
(provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance
Specified)â€.
We have congifured the sql server to accept remote connections with TCP/IP.
We also check in the PWA, the option to validate the user through forms and
still not working.

 

[Christophe Fiessinger [MSFT]]

have you followed the instructions documented on TechNet?
Configure SQL Membership Provider forms authentication for Project Server
2007
http://technet.microsoft.com/en-us/library/cc197472.aspx