Unable to access Admin following upgrade to version 10

Jamie O asked on September 14, 2017 12:00

The default 'administrator' account is unable to access Admin now that the upgrade to version 10 has completed. It worked fine in version 9. I see the following error:

Access denied

You're not a content editor and you cannot use administration.

I tried to use the CMSAdminEmergencyReset to create another admin account to login but that fails because it's trying to create columns in CMS_User that were deleted in version 10...

I also tried manually adding rows to UserRoles to give the administrator user the global admin and power user roles. Before I did that, the error I saw when trying to access admin was:

Access denied to resource 'CMS'

Permission for UI element 'Administration' is required.

Can anyone point me in the right direction?

Recent Answers


Prashant Verma answered on September 14, 2017 12:21

Hi Jamie,

Its a role and user privilege level issues , I recommend you to take backup of your Database before executing this query.

Check with this query and update your user privilege or admin user privilege using below query.

Update cms_user SET UserPrivilegeLevel=3 WHERE username='administrator'

Thanks

Happy to help you

0 votesVote for this answer Mark as a Correct answer

Jamie O answered on September 14, 2017 12:23

Hi Prashant,

Thanks for your help. Unfortunately the administrator user already has UserPrivilegeLevel=3.

Do you have any other suggestions?

Thanks,

0 votesVote for this answer Mark as a Correct answer

Prashant Verma answered on September 14, 2017 12:35 (last edited on September 14, 2017 12:42)

Set blank password in database for another admin rights users those having UserPrivilegeLevel=3 using

Update cms_user set userpassword='' where username=@Username OR UserID= @userid

I recommend you to update your kentico 10 with latest hotfix version 10.0.35

Thanks

0 votesVote for this answer Mark as a Correct answer

Jamie O answered on September 14, 2017 12:50

I already tried that and get the same error:

Access denied to resource 'CMS'

Permission for UI element 'Administration' is required.

The hotfix shouldnt affect this simple login, at least according to the list of bugs fixed in the hotfix. I agree the issue is related to permissions and roles but as far as I can see, the administrator user in in the correct admin roles and those admin roles have rows in the RoleUIElement table for the administration ui element as well.

What else could be missing?

0 votesVote for this answer Mark as a Correct answer

Trevor Fayas answered on September 15, 2017 14:14

have you tried the emergency admin reset? you add a app key in the web.config that resets a password and sets the level. it's in documentation in password reset (on mobile so hard to link)

0 votesVote for this answer Mark as a Correct answer

   Please, sign in to be able to submit a new answer.