Hi,
I was restoring demo data (*.bak) file into our instance but when I opened to AX 2012 R3 it was completely blank means no any modules visible and giving one error: "Insufficient rights to execute Menu Item Create default favorite group."
Then I wrote and executed one query in SQL Server Management Studio and it's fixed. Completed initial checklist and enjoying DAXing....
I was restoring demo data (*.bak) file into our instance but when I opened to AX 2012 R3 it was completely blank means no any modules visible and giving one error: "Insufficient rights to execute Menu Item Create default favorite group."
Then I wrote and executed one query in SQL Server Management Studio and it's fixed. Completed initial checklist and enjoying DAXing....
UPDATE USERINFO SET SID = 'S-1-5-21-2146773085-903363285-719344707-1910427'
UPDATE SYSBCPROXYUSERACCOUNT SET
SID = 'S-1-5-21-1721254763-462695806-1538882281-2782893'
UPDATE SYSUSERINFO SET
SQMUSERGUID = '00C6CD72-3148-4317-9324-1A3B11169379'
DELETE FROM
SYSSERVERCONFIG
DELETE FROM
SYSSERVERSESSIONS
DELETE FROM
SYSCLIENTSESSIONS
DELETE FROM SRSSERVERS
DELETE FROM
BATCHSERVERCONFIG
DELETE FROM
BATCHSERVERGROUP
DELETE FROM SYSUSERLOG
DELETE FROM
BICONFIGURATION
DELETE FROM
BIANALYSISSERVER
DELETE FROM
SMMPHONEPARAMETERS
DELETE FROM
EPGlobalParameters
DELETE FROM
EPWebSiteParameters
Happy DAXing......
Happy DAXing......
Good One
ReplyDelete