DNN 4.09.02 

SQL server 2005 express

StartJob	Begin Sql execution
Info	Executing Install.05.00.00.SqlDataProvider
StartJob	Start Sql execution: Install.05.00.00.SqlDataProvider file
Failure	SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Line 6: Incorrect syntax near 'max'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE TABLE dbo.[DMX_LongTexts] ( [Locale] [nvarchar] (6) NOT NULL, [ObjectId] [int] NOT NULL, [SubTypeKey] [nvarchar] (20) NOT NULL, [Text] [nvarchar] (max) NOT NULL, [TypeKey] [nvarchar] (3) NOT NULL ) System.Data.SqlClient.SqlException: Cannot alter table 'dbo.DMX_LongTexts' because this table does not exist in database 'DnnPrueba'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) ALTER TABLE dbo.[DMX_LongTexts] ADD CONSTRAINT [PK_DMX_LongTexts] PRIMARY KEY CLUSTERED ([Locale], [ObjectId], [SubTypeKey], [TypeKey]) System.Data.SqlClient.SqlException: Line 7: Incorrect syntax near 'MAX'. Must declare the variable '@Text'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.DMX_UpdateLongText @TypeKey NVarChar (3), @SubTypeKey NVarChar (20), @ObjectId Int, @Locale NVarChar (6), @Text NVarChar(MAX) AS UPDATE dbo.DMX_LongTexts SET [Text] = @Text WHERE [TypeKey] = @TypeKey AND [SubTypeKey] = @SubTypeKey AND [ObjectId] = @ObjectId AND [Locale] = @Locale System.Data.SqlClient.SqlException: Line 7: Incorrect syntax near 'MAX'. Must declare the variable '@Text'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.DMX_AddLongText @TypeKey NVarChar (3), @SubTypeKey NVarChar (20), @ObjectId Int, @Locale NVarChar (6), @Text NVarChar(MAX) AS INSERT INTO dbo.DMX_LongTexts ( [TypeKey], [SubTypeKey], [ObjectId], [Locale], Text ) VALUES ( @TypeKey, @SubTypeKey, @ObjectId, @Locale, @Text ) System.Data.SqlClient.SqlException: Line 9: Incorrect syntax near 'DISABLE'. Line 16: Incorrect syntax near 'ENABLE'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.DMX_SetDeleteRecursive @PortalId Int, @EntryId Int, @Delete BIT AS DECLARE @Path VARCHAR(2000) SET @Path = (SELECT [Path] FROM dbo.DMX_Entries WHERE EntryId=@EntryId AND PortalId=@PortalId)+'%'; DISABLE TRIGGER dbo.DMX_EntryUpdatePath ON dbo.DMX_Entries; UPDATE dbo.DMX_Entries SET Deleted=@Delete WHERE PortalId=@PortalId AND (LastVersionId=@EntryId OR [Path] LIKE @Path); ENABLE TRIGGER dbo.DMX_EntryUpdatePath ON dbo.DMX_Entries; System.Data.SqlClient.SqlException: Line 16: Incorrect syntax near 'DISABLE'. Line 19: Incorrect syntax near 'ENABLE'. Line 23: Incorrect syntax near 'DISABLE'. Line 39: Incorrect syntax near 'ENABLE'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE TRIGGER dbo.DMX_EntryUpdatePath ON dbo.DMX_Entries AFTER INSERT, UPDATE AS DECLARE @EntryId INT DECLARE @PortalId INT DECLARE @RowCount INT SELECT @RowCount=(SELECT COUNT(*) FROM INSERTED) IF @RowCount=1 BEGIN SELECT @EntryId = (SELECT EntryId FROM INSERTED); SELECT @PortalId = (SELECT PortalId FROM INSERTED); DISABLE TRIGGER dbo.DMX_EntryUpdatePath ON dbo.DMX_Entries; EXEC dbo.DMX_UpdatePaths @PortalId, @EntryId; EXEC dbo.DMX_SetLastModified @PortalId, @EntryId; ENABLE TRIGGER dbo.DMX_EntryUpdatePath ON dbo.DMX_Entries; END ELSE BEGIN DISABLE TRIGGER dbo.DMX_EntryUpdatePath ON dbo.DMX_Entries; DECLARE cursorX CURSOR FOR SELECT EntryId, PortalID FROM INSERTED BEGIN OPEN cursorX FETCH cursorX INTO @EntryId, @PortalId WHILE @@fetch_status=0 BEGIN FETCH cursorX INTO @EntryId, @PortalId; EXEC dbo.DMX_UpdatePaths @PortalId, @EntryId; EXEC dbo.DMX_SetLastModified @PortalId, @EntryId; END; CLOSE cursorX; DEALLOCATE cursorX; ENABLE TRIGGER dbo.DMX_EntryUpdatePath ON dbo.DMX_Entries; END; END
EndJob	End Sql execution: Install.05.00.00.SqlDataProvider file

I´m trying to install to server with SQL server 2005, but error

Connectionstrings tested:

      name="SiteSqlServer"
      connectionString="Server=(local);Database=DotNetNuke;uid=;pwd=;"
      providerName="System.Data.SqlClient" />
   -->

Errors:

Incorrect near 'MAX'