Cannot open AX 2012 environment during upgrade. Insufficient rights

(0) Share

Report

Posted on by Ghetz

3,011

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

I have the same question (0)

All responses (8)

Answers (0)

Ghetz 3,011 on at

Like (0)

Report
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.

Was this reply helpful? Yes No
Sohaib Cheema 49,024 User Group Leader on at

Like (0)

Report

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-'

Was this reply helpful? Yes No
Suggested answer

Luca Pellegrini on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Suggested answer

JII SAADUDDIN 1,832 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Suggested answer

JII SAADUDDIN 1,832 on at

Like (0)

Report

RE: Cannot open AX 2012 environment during upgrade. Insufficient rights

Your welcome. good to hear that..

Was this reply helpful? Yes No
Suggested answer

JII SAADUDDIN 1,832 on at

Like (0)

Report

RE: Cannot open AX 2012 environment during upgrade. Insufficient rights

Hi Praveen, is my commits resolved your issue?

Was this reply helpful? Yes No