Hola!
Tengo instalado SharePoint Services 3, SQL Server 2005 y Project Server 2007 en un servidor con Windows Server 2003.
Mi objetivo es realizar la autenticacion en project server 2007 de manera programatica a traves de Forms Autentication (estoy personalizando una pagina para acceder a la informacion de Project Server).
para la autenticacion de usuarios se debe crear SQL Membership Provider, el problema es al ejecutar la siguiente instruccion:
Primero utilizo la instruccion de esta manera
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727>aspnet_regsql.exe -A m -E
y obtengo el siguiente mensaje:
Start adding the following features:
Membership
..
------------------------------------------------------------------------------------------------------------------------
La segunda manera para utilizar la instruccion:
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)
Les agradeceria me colaboren como puedo crear el SQL memberShip Provider.
Gracias!!
