Notifications
Announcements
Facing error while running report in inventory & warehouse management >journal>moment>print
*This post is locked for comments
from LCS
Solution 1703064Access rights to the TempDB: SQL error description: [Microsoft][SQL Server Native Client 10.0][SQL Server]CREATE TABLE permission denied in database 'tempdb'.
Product and version
Microsoft Dynamics AX 2012 R2
PROBLEM
Problem accessing the tempdb, after moving the database from one environment to other. without sysadmin role for the AOS Service account. Error Message (10:57:10 am) Cannot execute a data definition language command on ().The SQL database has issued an error. Info Message (10:57:10 am) SQL error description: [Microsoft][SQL Server Native Client 10.0][SQL Server]CREATE TABLE permission denied in database 'tempdb'.Info Message (10:57:10 am) SQL statement: CREATE TABLE tempdb."DBO".t855_78FB159D2258439E971DD8C880FE187E (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 ,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 ,PARTITION BIGINT NOT NULL DEFAULT 5637144576 ,RECID BIGINT IDENTITY NOT NULL CHECK (RECID <> 0) )
MITIGATION
Grant database permissions to the AOS service account or re-install the AOS with correct rights See: technet.microsoft.com/.../cc551159.aspx
Link is no working
Duplicate thread.
community.dynamics.com/.../194805
This link is not working please share other
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 2 Most Valuable Professional
Nakul 2
Umar-Usman 1
