web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Trial Balance >Cann...
Microsoft Dynamics AX (Archived)

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

(0) ShareShare
ReportReport
Posted on by pooh 81

I am using AX 2012 and , suddenly when I go to General Ledger> Area Page>Trial Balance,  General Ledger> Area Page>Main account, below error message occur.

Have any idea about it?

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

SQL error description:[Microsoft][SQL Server Native Client 11.0][SQL Server][access denied for CREATE TABLE of database'tempdb'

SQL statement: CREATE TABLE tempdb. ''......

Thanks in advance.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hello pooh,

    Please have a developer taking a look into this. The following websites give you some hints for similar / related issue and what can be done:

    daxdude.blogspot.com/.../ax-error-cannot-execute-data-definition.html

    support.microsoft.com/.../error-message-when-you-synchronize-microsoft-dynamics-ax-with-a-table

    Best regards,

    Ludwig

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.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans