Well, for the fisrt time in months i got the first error in my dnn upgrade process since first install... untill now everything went fine but still i cannot complain Let´s see, is this error GRANT PERMISSION only!? I have the backup of my db and dnn previous to update, is it enought to restore, ask for GRANT PERMISSION to my host and after that to make the update?
Upgrading DotNetNuke
Current Assembly Version: 05.02.01
Current Database Version: 05.02.00
Upgrade Status Report
00:00:00.062 - Upgrading to Version: 05.02.01
00:00:00.281 - Executing Script: 05.02.01.SqlDataProvider Error! (see 05.02.01.log for more information)
00:00:02.172 - Executing Application Upgrades: 05.02.01 Success
00:00:02.234 - Cleaning Up Files: 05.02.01 Success
00:00:02.250 - Updating Config Files: 05.02.01 Success
00:00:02.313 - Performing General Upgrades
00:00:03.016 - Installing Optional Modules:
00:00:03.031 - Installing Package File HTML_Community_05.02.00_Install: Success
00:00:04.016 - Installing Optional Skins:
00:00:04.032 - Installing Optional Containers:
00:00:04.047 - Installing Optional Languages:
00:00:04.047 - Installing Optional Providers:
00:00:04.079 - Installing Package File AspNetMembershipProvider_05.02.00_Install: Success
00:00:04.172 - Installing Package File CorePermissionProvider_05.01.01_Install: Success
00:00:04.297 - Installing Package File DatabaseLoggingProvider_05.01.01_Install: Success
00:00:04.376 - Installing Package File DNNMembershipProvider_05.01.03_Install: Success
00:00:04.469 - Installing Package File DNNMenuNavigationProvider_05.01.00_Install: Success
00:00:04.563 - Installing Package File DNNTreeNavigationProvider_05.01.00_Install: Success
00:00:04.657 - Installing Package File FckHtmlEditorProvider_02.00.04_Install: Success
00:00:07.908 - Installing Package File FileBasedCachingProvider_05.01.03_Install: Success
00:00:08.048 - Installing Package File FileModuleCachingProvider_05.02.01_Install: Success
00:00:08.486 - Installing Package File MemoryModuleCachingProvider_05.02.01_Install: Success
00:00:08.642 - Installing Package File SchedulingProvider_05.02.01_Install: Success
00:00:08.908 - Installing Package File SearchIndexProvider_05.01.00_Install: Success
00:00:09.002 - Installing Package File SearchProvider_05.01.01_Install: Success
00:00:09.095 - Installing Package File SolpartMenuNavigationProvider_05.01.00_Install: Success
00:00:09.236 - Installing Optional AuthSystems:
00:00:09.236 - Installing Package File LiveID_01.00.01_Install: Success
00:00:09.471 - Installing Package File OpenID_02.00.00_Install: Success
00:00:09.689 - Installing Optional Packages:
Upgrade Complete
....
and the log says:
System.Data.SqlClient.SqlException: Cannot find the user 'SQL2008_user', because it does not exist or you do not have permission.
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)
GRANT EXECUTE TO [SQL2008_user]
Anyway, my site is working normaly for now( didn´t got the time to make all the tests...), but if i´m not wrong, i won´t be able to make the next update, true!?
Looks everybody has the same problem... so now, how can we fix it, in a begginers way!? And guys, you´ve allready seen this comming
Thanks!