I have tried upgrading to 5.1.1 from my site that was at 4.9.2.  I get the following errors:

00:00:00.042 -   Executing Script: 05.00.00.SqlDataProvider Error! (see 05.00.00.log for more information)
00:00:05.837 -   Executing Script: 05.00.01.SqlDataProvider Error! (see 05.00.01.log for more information)
00:00:07.859 -   Executing Script: 05.01.00.SqlDataProvider Error! (see 05.01.00.log for more information)
00:00:13.892 -   Executing Script: 05.01.01.SqlDataProvider Error! (see 05.01.01.log for more information)

Each of these files has essentiallly the same error message:

System.Data.SqlClient.SqlException: Incorrect syntax near '3'.
   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 Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters)
   at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
   at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText)
   at DotNetNuke.Data.SqlDataProvider.GrantStoredProceduresPermission(String Permission, String LoginOrRole)

if exists (select * from dbo.sysusers where name='public')  begin    declare @exec nvarchar(2000)     declare @name varchar(150)     declare sp_cursor cursor for select o.name as name     from dbo.sysobjects o     where ( OBJECTPROPERTY(o.id, N'IsProcedure') = 1 or OBJECTPROPERTY(o.id, N'IsExtendedProc') = 1 or OBJECTPROPERTY(o.id, N'IsReplProc') = 1 )     and OBJECTPROPERTY(o.id, N'IsMSShipped') = 0     and o.name not like N'#%%'     and (left(o.name,len('')) = '' or left(o.name,7) = 'aspnet_')     open sp_cursor     fetch sp_cursor into @name     while @@fetch_status >= 0       begin        select @exec = 'grant EXECUTE on ' +  @name  + ' to [public]'        execute (@exec)        fetch sp_cursor into @name       end     deallocate sp_cursor  end

If I check some of the tables/objects affected by all the scripts, it seems the scripts actually worked because I can see the changes in my DB.  So maybe the original errors are misleading?

ps I also did a restore of original site and upgraded to 4.9.4 first and then to 5.1.1 and the same thing happened

My SQL Server Express 2005 has a default collation of SQL_Latin1_General_CP1_CI_AS - is this the same?

Thanks, Richard

Hello,

I got exactly the same problème for a client who wants to migrate from dnn 4.9.4 pro to a 5.1.1 pro.

The database is French_CI_AS and the same for the server. I cannot change this param because the sql server is used for other databases.

I don't understand why dnn need to apply a GRANT Execute on storeproc when the account is dbo, it cannot work.

Regards,

JB