SQL error description: [Microsoft][SQL Server Native Client 11.0][SQL Server]CREATE TABLE permission denied in database 'tempdb'

SQL error description: [Microsoft][SQL Server Native Client 11.0][SQL Server]CREATE TABLE permission denied in database 'tempdb'

Hi Every one,

This is  my first blog.

I got a error while opening a CustTable form in AX2012R3 like..

“SQL error description: [Microsoft][SQL Server Native Client 11.0][SQL Server]CREATE TABLE permission denied in database 'tempdb'.” 
As show in below figure.

Solution:

After Some R&D on some administrations and I open my SQL using Run.

è   Windows + R

è   Type : SSMS

Press OK button.

Before that you have to know your AOS service is running on login Account or Network Account.

My service is running on Network Account. So I go for NT AUTHORITY\NETWORK SERVICE.

SQL will be opened after that I went to securities --> Login --> NT AUTHORITY\NETWORK SERVICE

Right Click --> Properties --> Select User Mapping --> Select TempDB --> And below select db_ddladmin, db_datareader and db_datawriter.

Press OK.

And opened the form. This issues never repeat again.

Please find the below figure.

Thank you.

Any concern about this blog will be accepted.