Hi, the wizard crashes during installation at 18% with this error log:
[ERROR] DotNetNuke.Services.Upgrade.Upgrade System.Data.SqlClient.SqlException (0x80131904): User does not have permission to perform this action.
But my user is dbo in SQL Server database.
This is the complete error message:
0:02 Minuti | 18% ERRORE si รจ verificato - System.Data.SqlClient.SqlException (0x80131904): User does not have permission to perform this action. User does not have permission to perform this action. User does not have permission to perform this action. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDatabaseConnectionProvider.ExecuteNonQuery(String connectionString, CommandType commandType, Int32 commandTimeout, String query) at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script, Int32 timeoutSec) ClientConnectionId:69477b80-5b53-4efd-ae94-6d1c61cab922 Error Number:15247,State:1,Class:16 /*************************************************************/ /*************************************************************/ -- --Create Membership roles -- IF ( NOT EXISTS ( SELECT name FROM sys.database_principals WHERE [type] = 'R' AND name = N'aspnet_Membership_FullAccess' ) ) CREATE ROLE aspnet_Membership_FullAccess IF ( NOT EXISTS ( SELECT name FROM sys.database_principals WHERE [type] = 'R' AND name = N'aspnet_Membership_BasicAccess' ) ) CREATE ROLE aspnet_Membership_BasicAccess IF ( NOT EXISTS ( SELECT name FROM sys.database_principals WHERE [type] = 'R' AND name = N'aspnet_Membership_ReportingAccess' ) ) CREATE ROLE aspnet_Membership_ReportingAccess System.Data.SqlClient.SqlException (0x80131904): User or role 'aspnet_Membership_FullAccess' does not exist in this database. User or role 'aspnet_Membership_FullAccess' does not exist in this database. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDatabaseConnectionProvider.ExecuteNonQuery(String connectionString, CommandType commandType, Int32 commandTimeout, String query) at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script, Int32 timeoutSec) ClientConnectionId:69477b80-5b53-4efd-ae94-6d1c61cab922 Error Number:15410,State:1,Class:11 EXEC sp_addrolemember N'aspnet_Membership_BasicAccess', N'aspnet_Membership_FullAccess' EXEC sp_addrolemember N'aspnet_Membership_ReportingAccess', N'aspnet_Membership_FullAccess' System.Data.SqlClient.SqlException (0x80131904): Cannot find the user 'aspnet_Membership_BasicAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Membership_BasicAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Membership_BasicAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Membership_BasicAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Membership_BasicAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Membership_BasicAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Membership_BasicAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Membership_BasicAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Membership_BasicAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Membership_BasicAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Membership_ReportingAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Membership_ReportingAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Membership_ReportingAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Membership_ReportingAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Membership_ReportingAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Membership_ReportingAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Membership_ReportingAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Membership_ReportingAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Membership_ReportingAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Membership_ReportingAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Membership_FullAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Membership_FullAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Membership_FullAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Membership_FullAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Membership_FullAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Membership_FullAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Membership_FullAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Membership_ReportingAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Membership_ReportingAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Membership_ReportingAccess', because it does not exist or you do not have permission. Cannot grant, deny, or revoke permissions to sa, dbo, entity owner, information_schema, sys, or yourself. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDatabaseConnectionProvider.ExecuteNonQuery(String connectionString, CommandType commandType, Int32 commandTimeout, String query) at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script, Int32 timeoutSec) ClientConnectionId:69477b80-5b53-4efd-ae94-6d1c61cab922 Error Number:15151,State:1,Class:16 -- --Stored Procedure rights for BasicAcess -- GRANT EXECUTE ON dbo.aspnet_Membership_GetUserByUserId TO aspnet_Membership_BasicAccess GRANT EXECUTE ON dbo.aspnet_Membership_GetUserByName TO aspnet_Membership_BasicAccess GRANT EXECUTE ON dbo.aspnet_Membership_GetUserByEmail TO aspnet_Membership_BasicAccess GRANT EXECUTE ON dbo.aspnet_Membership_GetPassword TO aspnet_Membership_BasicAccess GRANT EXECUTE ON dbo.aspnet_Membership_GetPasswordWithFormat TO aspnet_Membership_BasicAccess GRANT EXECUTE ON dbo.aspnet_Membership_UpdateUserInfo TO aspnet_Membership_BasicAccess GRANT EXECUTE ON dbo.aspnet_Membership_GetNumberOfUsersOnline TO aspnet_Membership_BasicAccess GRANT EXECUTE ON dbo.aspnet_CheckSchemaVersion TO aspnet_Membership_BasicAccess GRANT EXECUTE ON dbo.aspnet_RegisterSchemaVersion TO aspnet_Membership_BasicAccess GRANT EXECUTE ON dbo.aspnet_UnRegisterSchemaVersion TO aspnet_Membership_BasicAccess -- --Stored Procedure rights for ReportingAccess -- GRANT EXECUTE ON dbo.aspnet_Membership_GetUserByUserId TO aspnet_Membership_ReportingAccess GRANT EXECUTE ON dbo.aspnet_Membership_GetUserByName TO aspnet_Membership_ReportingAccess GRANT EXECUTE ON dbo.aspnet_Membership_GetUserByEmail TO aspnet_Membership_ReportingAccess GRANT EXECUTE ON dbo.aspnet_Membership_GetAllUsers TO aspnet_Membership_ReportingAccess GRANT EXECUTE ON dbo.aspnet_Membership_GetNumberOfUsersOnline TO aspnet_Membership_ReportingAccess GRANT EXECUTE ON dbo.aspnet_Membership_FindUsersByName TO aspnet_Membership_ReportingAccess GRANT EXECUTE ON dbo.aspnet_Membership_FindUsersByEmail TO aspnet_Membership_ReportingAccess GRANT EXECUTE ON dbo.aspnet_CheckSchemaVersion TO aspnet_Membership_ReportingAccess GRANT EXECUTE ON dbo.aspnet_RegisterSchemaVersion TO aspnet_Membership_ReportingAccess GRANT EXECUTE ON dbo.aspnet_UnRegisterSchemaVersion TO aspnet_Membership_ReportingAccess -- --Additional stored procedure rights for FullAccess -- GRANT EXECUTE ON dbo.aspnet_Users_DeleteUser TO aspnet_Membership_FullAccess GRANT EXECUTE ON dbo.aspnet_Membership_CreateUser TO aspnet_Membership_FullAccess GRANT EXECUTE ON dbo.aspnet_Membership_SetPassword TO aspnet_Membership_FullAccess GRANT EXECUTE ON dbo.aspnet_Membership_ResetPassword TO aspnet_Membership_FullAccess GRANT EXECUTE ON dbo.aspnet_Membership_UpdateUser TO aspnet_Membership_FullAccess GRANT EXECUTE ON dbo.aspnet_Membership_ChangePasswordQuestionAndAnswer TO aspnet_Membership_FullAccess GRANT EXECUTE ON dbo.aspnet_Membership_UnlockUser TO aspnet_Membership_FullAccess -- --View rights -- GRANT SELECT ON dbo.vw_aspnet_Applications TO aspnet_Membership_ReportingAccess GRANT SELECT ON dbo.vw_aspnet_Users TO aspnet_Membership_ReportingAccess GRANT SELECT ON dbo.vw_aspnet_MembershipUsers TO aspnet_Membership_ReportingAccess /*************************************************************/ /*************************************************************/ /*************************************************************/ /*************************************************************/ DECLARE @command nvarchar(4000) SET @command = 'REVOKE EXECUTE ON [dbo].aspnet_RegisterSchemaVersion FROM ' + QUOTENAME(user) EXECUTE (@command)
Thank you
Thank you for your answer.
I'm sure that my user has dbo privileges.
I'll try the tool suggested and I'll write you a feedback soon.
Best regards
Sorry but nvQuickSite tool works only in local machine.
I've to install DNN on a remote server.
I only have FTP, Plesk and MyLittleAdmin to administrate my hosting area.
You can see the permission screenshot here: https://jmp.sh/1SBs0c3
Any other suggestions?
Thanks
Posted By Davide Martini on 26 Jun 2020 04:10 AM Sorry but nvQuickSite tool works only in local machine. I've to install DNN on a remote server. I only have FTP, Plesk and MyLittleAdmin to administrate my hosting area. You can see the permission screenshot here: https://jmp.sh/1SBs0c3 Any other suggestions? Thanks
Even if you had direct server access, nvQuickSite is not indetended for use on a server (I asked the developer about this and he agreed). It takes a few "NTFS security shortcurts" that are fine on a local machine, but not on the server IIRC.
Your screen print is not visible, can you post it again?
Hi,
I try to send the snapshot again: https://jumpshare.com/v/1KBcjg8VPe5CFgkaYHMf
But it is only and image where you can see that the user is dbo for the database.
With the hosting administrator (IT) we tried to check all permission both for user and schema. Everything seems to be activated and the user has all permissions for everything.
But the install wizard fails at 18% as usually.
Really, I don't know how to proceede.
Well, I still think it must be something environmental, as DNN normally installs without issues when all settings are correct. One thing you could check is if it's a database size limitation (probably not, I would check it anyway). Is there any other info in "Portals/_Default/Logs/2020.06.26.log.resources"?
I have seen installer timeouts on azure, but there the installer just stopped because of the timeout. What you could also try is install DNN on your local machine, make a backup and and move it over to the server.
These Forums are dedicated to the discussion of DNN Platform.
For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:
Awesome! Simply post in the forums using the link below and we'll get you started.