Error - While opening the Ax 2012

Cannot execute a data definition language command on ().
The SQL database has issued an error.

SQL error description: [Microsoft][SQL Server Native Client 10.0][SQL Server]CREATE TABLE permission denied in database ‘tempdb’.

SQL statement: CREATE TABLE tempdb.“DBO”.t855_C07572659F8C4A71A7D5D435FE97336D (USERID NVARCHAR(8) COLLATE SQL_LATIN1_GENERAL_CP1_CI_AS NOT NULL DEFAULT ‘’ ,TYPE INT NOT NULL DEFAULT 0 ,COMPUTERNAME NVARCHAR(30) COLLATE SQL_LATIN1_GENERAL_CP1_CI_AS NOT NULL DEFAULT ‘’ ,CLIENTTYPE INT NOT NULL DEFAULT 0 ,DEL_LOGOUTTIME INT NOT NULL DEFAULT 0 ,DEL_LOGOUTDATE DATETIME NOT NULL DEFAULT ‘1900-01-01 00:00:00.000’ ,BUILDNUM NVARCHAR(10) COLLATE SQL_LATIN1_GENERAL_CP1_CI_AS NOT NULL DEFAULT ‘’ ,SESSIONID INT NOT NULL DEFAULT 0 ,TERMINATEDOK INT NOT NULL DEFAULT 0 ,LOGOUTDATETIME DATETIME NOT NULL DEFAULT ‘1900-01-01 00:00:00.000’ ,LOGOUTDATETIMETZID INT NOT NULL DEFAULT 37001 ,CREATEDDATETIME DATETIME NOT NULL DEFAULT dateadd(ms, -datepart(ms,getutcdate()), getutcdate()) ,RECVERSION INT NOT NULL DEFAULT 1 ,RECID BIGINT IDENTITY NOT NULL CHECK (RECID <> 0) )

Above three errors I am getting, while I am opening Ax 2012 client.

URGENT please…!!!

Hi Abhishek,

Try to synchronize your database once.

And try to check the Event viewer you may get some clue over there.

Also please check the table which it’s throwing in the error, Sometime this kind of error generates when your field name and keywords is same.For ex: if your field name is ‘update’ and we know that this is also one of the keyword in AX.

Hi Vishal,

Thanks so much for your comment.

I have resolved it, by giving db Owner, abd db_ddl related roles to Guest user, in TempDB.

It works fine now.

Abhishek