Microsoft Dynamics AX (Archived)

AX 2012 - Create Table permission denied in database 'tempdb'

(0) Share

Report

Posted on by MuthukumaranAX

2,903

Hi All,

I'm running a script to update the vendor addresses and i'm getting the error like

"Create Table permission denied in database 'tempdb'"

even after sufficient access has been provided in the tempdb still this error persists.

any suggestion to fix this resolve would be apprepricated

thanks.

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

Heinz Schweda 1,367 on at

Like (0)

Report
Hi, a colleague of mine had this error some time ago, maybe the following link helps:

http://msdn.microsoft.com/en-us/library/gg845661.aspx

Remember also, that:

Only processes that run on the server tier can instantiate TempDB tables

The domain account that you use for the Microsoft Dynamics AX service must have read and write access to the TempDB database.

Regards, Heinz

Was this reply helpful? Yes No
MuthukumaranAX 2,903 on at

Like (0)

Report

Hi Heinz,

Thanks for your response.

The AOS service account has enough permission to tempdb and also in my code i am not using/calling any temp tables. It's totally weird for me.

~ Muthu

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Hi,

Sorry for asking, but are you sure that AOS service account has permissions?

All permissions for tempdb are lost each time the SQL Server is restarted. Dynamics AX installer creates a stored procedure to restore AOS account permissions in such cases (in master database, something like "CREATETEMPDBPERMISSIONS_AOS_01")

In case you changed the AOS account recently or just moved the database from another SQL Server than the stored procedure is missing and SQL Server restart will cause such error.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

reboot AOS and install the update of this post.

community.dynamics.com/.../74732.aspx

Was this reply helpful? Yes No
Ali Zaidi 4,657 on at

Like (1)

Report

I got this error once, I follow the following link

techguns.wordpress.com/.../create-table-permission-denied-in-database-

tempdb-in-dynamics-ax-2012-r2/

Was this reply helpful? Yes No