Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Suggested answer

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

Posted on by 75

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.

Categories:
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Trial Balance >Cannot execute a data definition language command on ().The SQL database has issued an error.

    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

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,420 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,672 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans