Hello,

     I'm trying to do a DNN upgrade from 4.9.5, but the trick is that this DNN instance has a different database owner than the default, and the upgrade fails, basically none of the sql scripts run successfully because of some permission error. Has anyone used DNN with database owner other than the default? Any help would be greatly appreciated.

 Istvan

Hi Sebastian,

Thanks for the quick answer, I don't know why the site didn't notify me about it, I checked the notification box, but anyway: right now I cannot provide you with exact log files, but the same text kept repeating all over the logs, if I remember correctly, it was something like: Cannot find user xxxxx (which is the database owner). Either it doesn't exist or you don't have permission. I will attempt to upgrade again, but on the upgrade path, the suggested route was from 4.9.5 to 5.4.4, I don't see the 5.2.3 in between. Is that the version that I can upgrade to without problems? Or do I need to do anything special to be able to upgrade?

Thanks

Problem is, I don't even get to the point where I upgrade to 5.x. Site is 4.9.0 and I want to upgrade to 4.9.5. Here's a part from one of the log files, Every log file is the same:

 

System.Data.SqlClient.SqlException: Cannot find the object 'dev245_UpdateAffiliateStats', because it does not exist or you do not have permission.
Cannot find the object 'dev245_GetTabModuleSetting', because it does not exist or you do not have permission.
Cannot find the object 'dev245_UpdateAnonymousUser', because it does not exist or you do not have permission.
Cannot find the object 'dev245_Dashboard_GetControls', because it does not exist or you do not have permission.
Cannot find the object 'dev245_DeleteRoleGroup', because it does not exist or you do not have permission.
Cannot find the object 'dev245_AddTabModule', because it does not exist or you do not have permission.
Cannot find the object 'dev245_GetPortalRoles', because it does not exist or you do not have permission.
Cannot find the object 'dev245_GetScheduleByEvent', because it does not exist or you do not have permission.
Cannot find the object 'dev245_DeleteModulePermissionsByUserID', because it does not exist or you do not have permission.
Cannot find the object 'dev245_UpdateScheduleHistory', because it does not exist or you do not have permission.
.
.
.
.

Cannot find the object 'dev245_GetHostSetting', because it does not exist or you do not have permission.
   at System.Data.SqlClient.SqlConnection. (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)

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('dev245_')) = 'dev245_' 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