Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Cannot open AX 2012 en...
Microsoft Dynamics AX (Archived)

Cannot open AX 2012 environment during upgrade. Insufficient rights

(0) ShareShare
ReportReport
Posted on by Ghetz 2,983

I was in the middle of upgrading from AX4 to AX 2012 R3.

I had some issues, and had to restart the 2012 AOS service. It seems like the UserInfo table has been already loaded from AX4 during the Bulk Copy jobs, but something must be missing in the security roles, because I can't access the environment now. When I open the AX client, it says "Insufficient rights"

 

I don't want to start the upgrade process from scratch, so I need a way to open the client and continue upgrade.

In SQL Server, I can see that My user's SID is in the Admin user of UserInfo table. Is there anything I can do in SQL so that my user is assigned the "System administrator" role?

*This post is locked for comments

  • Suggested answer
    JII SAADUDDIN Profile Picture
    JII SAADUDDIN 1,832 on at
    RE: Cannot open AX 2012 environment during upgrade. Insufficient rights

    Hi Praveen, is my commits resolved your issue?

  • Suggested answer
    JII SAADUDDIN Profile Picture
    JII SAADUDDIN 1,832 on at
    RE: Cannot open AX 2012 environment during upgrade. Insufficient rights

    Your welcome. good to hear that..

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Cannot open AX 2012 environment during upgrade. Insufficient rights

    Hi Jii, Thanks for the response.

    We solved the issue, added permission of system administrator using SQL on user info table for my ID.

    obtained max(RECID) and update a record.

  • Suggested answer
    JII SAADUDDIN Profile Picture
    JII SAADUDDIN 1,832 on at
    RE: Cannot open AX 2012 environment during upgrade. Insufficient rights

    Hi, there is a lot of speculation right policies.

    First, you have rights on your SQL Server Management.

    Second, you have rights on your domain account.

    Third is you also have rights on your AX Roles

    the best you contact your sa administrator.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Cannot open AX 2012 environment during upgrade. Insufficient rights

    Hi Team, 

    I have the same issue on AX 2012 during running Data upgrade checklist on AX 2012 R3. 

    Deployed Developer license, post which we get the message " insufficient rights" while opening AX client and clicking on Data Upgrade checklist.

    Tried using the SQL query to obtain Admin rights to my ID. No Luck!

    Could you help us?

  • Suggested answer
    Luca Pellegrini Profile Picture
    Luca Pellegrini on at
    RE: Cannot open AX 2012 environment during upgrade. Insufficient rights

    Hi Ghetz,

    try this:

    update userinfo

    set

    SID = 'xxxsid',

    NETWORKALIAS='xxxalias',

    NETWORKDOMAIN = 'xxxdomain'

    where id = 'Admin'

    Replace the xxx values with your user information.

    Doing this you'll set your username as Admin in AX and it should solve the problem.

    I hope this helps.

    Best regards,

    Luca Pellegrini

  • Sohaib Cheema Profile Picture
    Sohaib Cheema 46,610 User Group Leader on at
    RE: Cannot open AX 2012 environment during upgrade. Insufficient rights

    you can see what has been assigned with your user and what roles are available as standard, for your analysis. Run following on SQL Server

    USE MicrosoftDynamicsAX

    select * from SecurityUserRole

    WHERE USER_ = 'Admin'

    USE MicrosoftDynamicsAX_model

    select * from SECURITYROLE

    where SECURITYROLE.AOTNAME = '-SYSADMIN-'

  • Ghetz Profile Picture
    Ghetz 2,983 on at
    RE: Cannot open AX 2012 environment during upgrade. Insufficient rights

    OK, just found a query to see a list of users and roles in AX 2012 from SQL:

    SELECT
 T1.USER_,  t3.AOTNAME
FROM
SECURITYUSERROLE T1 CROSS
JOIN
USERINFO T2 cross
join
 [AX2012MGSTD_model].[dbo].SECURITYROLE t3
WHERE
 T1.ASSIGNMENTSTATUS=  1 AND T1.USER_=T2.ID and t3.RECID = t1.SECURITYROLE


    Just had to make sure that there was a line for my user in the SECURITYUSERROLE table with the correct SECURITY role.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans