web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums 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) Share

Report

Report

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)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

CP04-islander 39

#2

#3

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans