This blog is dedicated to all my technical learnings and findings. As they say use all the brains you have and borrow all the brains you can, so this is my share of lending my learnings to all you guys out there. I would like to acknowledge here that some parts of these posts would be reproduced as a part of my web-browsing mainly because having it all in one place is far more convenient.
Tuesday, May 15, 2018
Move AX database between environment
If the active directories are different then the sysadmin role mapping with the active directory will be required to be updated
select SID, Networkdomain, networkalias from userinfo where networkalias = ''
Find the SID for the user to be mapped in the new Active directory
Copy the new SID for the desired user and update the same in the userinfo table
update userinfo set SID='', Networkdomain = '', networkalias = '' where id = 'admin'