Resolved | Create table permission denied issue in tempdb

Error: CREATE TABLE permission denied in database ‘tempdb’ in dynamics AX 2012 R2.

Background of the issue: This issue appeared after login and navigating to any forms in Microsoft Dynamics AX.

Solution: When I checked, there are no proper rights to the guest account on the tempdb table. After providing db_ddladmin, db_owner, db_securityadmin roles to the guest user, issue got resolved.

Few of other bloggers suggested in comments, providing the same permissions to AOS service account will also resolve the issue.

**Review1: Content modified on 17/Apr/2018.
**Blog posted on 30/Apr/2014.
**If this post helped you, please Like or comment.

5 comments

  1. Hii Ravi, Thanks for this helpful solution…

  2. This one you have to do from each user login .. instead of that you can just follow the link and give the same privileges to AOS user.
    http://axfaq.blogspot.in/2012/05/tempdb-access-rights-ax-2012.html

  3. Thank you Ravi.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: