Create SQL Memebership Provider for Form autentication Project ser

[Julian David]

Hello

I had installed SharePoint Services 3, SQL Server 2005 and Project Server
2007 in Windows Server 2003.

I need to use PSI for accesing to Project Server 2007 information through
Forms Autentication in a personal web site. Then is necesary to create SQL
membership provider to acces.

I'm using the next command and I get the next message:
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727>aspnet_regsql.exe -A m -E

Start adding the following features:
Membership

................
An error has occurred. Details of the exception:
A network-related or instance-specific error occurred while establishing a
conne
ction to SQL Server. The server was not found or was not accessible. Verify
that
the instance name is correct and that SQL Server is configured to allow
remote
connections. (provider: Named Pipes Provider, error: 40 - Could not open a
conne
ction to SQL Server)

Unable to connect to SQL Server database.





------------------------------------------------------------------------------------------------------------------------

I try with the second option :


C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727>aspnet_regsql.exe -S
\\.\pipe\mssql$microsoft##ssee\sql\query -A m -E
y se obtiene el siguiente mensaje:

Start adding the following features:
Membership

...
An error occurred during the execution of the SQL file 'InstallCommon.sql'.
The
SQL error number is 33003 and the SqlException message is: DDL statement is
not
allowed.
SQL Server: \\.\pipe\mssql$microsoft##ssee\sql\query
Database: aspnetdb
SQL file loaded:
InstallCommon.sql

Commands failed:

CREATE PROCEDURE [dbo].aspnet_Setup_RestorePermissions
@name sysname
AS
BEGIN
DECLARE @object sysname
DECLARE @protectType char(10)
DECLARE @action varchar(60)
DECLARE @grantee sysname
DECLARE @cmd nvarchar(500)
DECLARE c1 cursor FORWARD_ONLY FOR
SELECT Object, ProtectType, [Action], Grantee FROM
#aspnet_Permissions w
here Object = @name

OPEN c1

FETCH c1 INTO @object, @protectType, @action, @grantee
WHILE (@@fetch_status = 0)
BEGIN
SET @cmd = @protectType + ' ' + @action + ' on ' + @object + ' TO ['
+ @
grantee + ']'
EXEC (@cmd)
FETCH c1 INTO @object, @protectType, @action, @grantee
END

CLOSE c1
DEALLOCATE c1
END

SQL Exception:
System.Data.SqlClient.SqlException: DDL statement is not allowed.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
Boolea
n breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception
, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObj
ect stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cm
dHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler,
Tds
ParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String
methodName,
Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult
res
ult, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at System.Web.Management.SqlServices.ExecuteFile(String file, String
server,
String database, String dbFileName, SqlConnection connection, Boolean
sessionSta
te, Boolean isInstall, SessionStateType sessionStatetype)


I need to execute the command to create the SQL membership provider, but I
had not results! the problem is with the microsoft##ssee embebed database.
And the Project Server 2007 Instalation is not a server farm configuration.
I hope you can help me.
Thank you so much!!