No User with Administrative Rights RRS feed

  • Question

  • I am trying to make changes, add users and remove users.

    Unfortunately it appearst that there is not a user on the CRM side that has administrative rights.

    I have logged on as my user, I have administrator rights to the network, and as the network administrator.

    Would appreciate any ideas.

    Thursday, December 29, 2011 5:15 PM

All replies

  • The fact that you are a Network Administrator does not mean you're the System Administrator in Dynamics CRM. I don't thini that there is not an Administrator user, for example the Deployment Manager has System Administrator Role. Another thing that you should consider is that in CRM you can't delete any user, you only can disable him/her.

    Thursday, December 29, 2011 10:33 PM
  • Thanks for the reply.  When I goto Maintain users I get the same error if I try to disable a user or add a new user.  So far as a work around I have removed all access to any roles for the people that no longer need to use, but we have new people to setup and seem to be blocked.

    Settings - Administration - Users - New User - Enter domain logon and let form populate.  Set access to full.  Message just says An error has occured and links to community or support.

    Same menu path, try to change a user to have Administrative rights, same message.

    My undestanding was that to disable a user or create a new user, the user that you connect with had to have Administrative access, verses full or read only.  Reviewing all of the users that are in CRM, none of them have Administrative.


    Wednesday, January 4, 2012 1:24 PM
  • Hi CSCI,

    You can give your user account admin rights, the process to reassign a full administrator role you need full permissions on the database. Get the administrator role GUID from the RoleBase table, then identify your own GUID and replace your role GUID with the admin GUID on the SystemUserRoles table.

    If you not familiar with the CRM tables, read this step-by-step tutorial:



    Visit my blog for CRM material, improving performance, kerberos, IFD, development tips, etc. :) http://quantusdynamics.blogspot.com
    • Edited by nrodriEditor Saturday, January 7, 2012 11:08 PM
    • Proposed as answer by nrodriEditor Thursday, February 16, 2012 9:43 PM
    Saturday, January 7, 2012 11:06 PM
  • Hello Nuno,

    Awesome walk through but the tables do not match, what I see in SQL Server to what is in your screen prints.

    Your walk through:

    select * from SystemUserBase where FullName='System

    This table does not exist on our version, we have:

    SystemUser, SystemUserAuthentication

    any thoughts.

    Thursday, February 16, 2012 6:42 PM
  • Here is another update, and rather unusual, my user id does have the System Administrator Role assigned, but I cannot create new users.
    Thursday, February 16, 2012 6:46 PM
  • Hi,

    What message you getting while creating users?

    I suggest you to check your license?

    is it a cal license or Server license?


    Khaja Mohiddin|||||http://www.dynamicsexchange.com/

    Thursday, February 16, 2012 7:48 PM
  • Hi CSCI,

    you are doing the query on the wrong database is not the MSCRM_CONFIG but the ORganisation_MSCRM

    Visit my blog for CRM material, improving performance, kerberos, IFD, development tips, etc. :) http://quantusdynamics.blogspot.com

    • Edited by nrodriEditor Thursday, February 16, 2012 9:29 PM
    Thursday, February 16, 2012 9:24 PM