Issue: CREATE TABLE permission denied in database ‘tempdb’ in dynamics AX 2012 R2.
Explanation: The above issue will appear after login into Dynamics AX and if you are going to navigate any forms getting the same error.
Solution: There are no proper rights to the guest account on tempdb table. In my case, the issue got resolved after adding db_ddladmin, db_owner, db_securityadmin roles to the guest user.
Refer below screenshot for assigning roles to the guest user.
Thanks for reading my blog posting. If you have any questions/suggestions, please do comments below. Click on follow button and enter your email address to get latest updates from the blog.
“Yours, Ravi Theja Madisetty”