• Login
  • Register

DNN Forums

A community discussion page. We're starting from scratch, so...let's get the party started!

Permission errors

You are not authorized to post a reply.
Sort:


New Member


Posts:13
New Member

    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



    Veteran Member


    Posts:485
    Veteran Member

      Check and make sure that the user has dbowner privileges, IIRC.

      If you want to take ALL of the pain out of DNN installations, take a look at nvQuickSite. This is an open source project created by our friends at nVisionative and it's really one of the best tools available. A few mouse clicks and you set up literally every piece of a DNN installation.
      Joe Craig
      DNN MVP
      Patapsco Research Group


      New Member


      Posts:13
      New Member

        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



        New Member


        Posts:13
        New Member

          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



          Veteran Member


          Posts:563
          Veteran Member

            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?
             

             

             



            New Member


            Posts:13
            New Member

              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.



              Veteran Member


              Posts:563
              Veteran Member

                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.



                New Member


                Posts:13
                New Member

                  DONE!!!!!
                  My solution:
                  - deleted the database created during first installation (wizard)
                  - deleted the user created by the wizard
                  - deleted all site files
                  - unzipped again into server directory
                  - recreate an ampty database
                  - recreate the user and setted the dbo permission on the database
                  - restart the wizard
                  - ALL DONE!!!!!!

                  Wizard keeps all settins into second step. The only way I've found to restart the wizard from beginning is to clean everything and restart.

                  Thank you and have a nice day


                  Veteran Member


                  Posts:485
                  Veteran Member

                    Great!
                    Joe Craig
                    DNN MVP
                    Patapsco Research Group
                    You are not authorized to post a reply.

                    These Forums are dedicated to discussion of DNN Platform.

                    For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

                    1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
                    2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
                    3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
                    4. No Flaming or Trolling.
                    5. No Profanity, Racism, or Prejudice.
                    6. Site Moderators have the final word on approving / removing a thread or post or comment.
                    7. English language posting only, please.

                    Would you like to help us?

                    Awesome! Simply post in the forums using the link below and we'll get you started.

                    Get Involved